extract database content

My server had the following main tool before the harddiak gone dead
MS Windows server 2003
MS Sharepoint Portal Server 2003
MS SQL Server 2000 Enterprise
I already have a new harddisk and the above key software installed. Now
is to get the data back in place. The main data i had backup separetely
and wanted to restore is a .SPB file created using Sharepoint Backup
tool. I have since manage to use SQL Enterprise Manager to restore the
content of the .SPB file into a new database.
I have been trying to restore the data using Sharepoint Restore tool
but have yet to see any result. I am exploring other alternatives. One
of the alternative in my mind is to extract the content of this
database using any tools suitable. Most of the data in this database
are MS office document, PDF file and images. I am not familiar with SQL
database and hence not sure if there are tools like that readily
available.
Thank you very much in advance for any advice to get the file extracted
such that I can rebuild my system.
Best Regards
ChanHi,
just to close the loop,
I found a tool that works very well so far in extracting the files in
my databases. It is capable of viewing all the version history but not
able to retrieved them, anyway who cares this since I can extract the
latest files :)
http://www.sharepoint-france.com/Pr...ery/Release.rar
Best Regards
Chan

extract data from SSAS and feed to a formated file / another application

Hello,

I'm looking for a tool which is able to connect to SSAS Cube, extract data and transfer it to a file (as interface to another application). With reporting services I can extract Cube data but can't transform to the right file format and with SSIS I can't extract the data from Cube.

Do you have any ideas, tools, links, etc. ?

Thanks in advanced!

-flyall-

Why would you say: "with SSIS I can't extract the data from Cube" - what is the issue? Others in the forum are apparently using SSIS for this purpose, like:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1203503&SiteID=1

>>

...

I am populating flatfiles from MDX queries run i SSIS against AS databases.

...

>>

|||

Hi,

I tried a MDX query in "OLE DB Source" -> "SQL Command" but the tool can't identify the output coumns.

Is this a typical problem?

cu

-flyall-

|||

You can do it if you use a Data Reader source, but you should also be aware that all of your columns will be Unicode Text (ie the DT_NText type); this is because the AS provider isn't strongly typed because there are quite valid scenarios where a measure could return values of different types, such as a numeric value or a string. It's perfectly possible to do the conversion downstream if you need to though.

HTH,

Chris

sql

extract data from SSAS and feed to a formated file / another application

Hello,

I'm looking for a tool which is able to connect to SSAS Cube, extract data and transfer it to a file (as interface to another application). With reporting services I can extract Cube data but can't transform to the right file format and with SSIS I can't extract the data from Cube.

Do you have any ideas, tools, links, etc. ?

Thanks in advanced!

-flyall-

Why would you say: "with SSIS I can't extract the data from Cube" - what is the issue? Others in the forum are apparently using SSIS for this purpose, like:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1203503&SiteID=1

>>

...

I am populating flatfiles from MDX queries run i SSIS against AS databases.

...

>>

|||

Hi,

I tried a MDX query in "OLE DB Source" -> "SQL Command" but the tool can't identify the output coumns.

Is this a typical problem?

cu

-flyall-

|||

You can do it if you use a Data Reader source, but you should also be aware that all of your columns will be Unicode Text (ie the DT_NText type); this is because the AS provider isn't strongly typed because there are quite valid scenarios where a measure could return values of different types, such as a numeric value or a string. It's perfectly possible to do the conversion downstream if you need to though.

HTH,

Chris

Extended Stored Procedures

The database I am setting up requires a dll file to be added to extended
stored prcoedures - "Using a Microsoft tool such as Enterprise Manager, add
the file to the extended stored prcoedures already installed on SQL Server."
Where/how is this done?
Thank you.
Regards,
DianeYou can run a query like the one below from Query Analyzer. See the Books
Online for more information.
EXEC sp_addextendedproc 'MyFunction', 'MyApp.dll'
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:508ECDA1-08D8-4593-BAF8-628108DDFF0B@.microsoft.com...
> The database I am setting up requires a dll file to be added to extended
> stored prcoedures - "Using a Microsoft tool such as Enterprise Manager,
> add
> the file to the extended stored prcoedures already installed on SQL
> Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane|||Diane wrote:
> The database I am setting up requires a dll file to be added to
> extended stored prcoedures - "Using a Microsoft tool such as
> Enterprise Manager, add the file to the extended stored prcoedures
> already installed on SQL Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane
See "sp_addextendedproc" and "Creating Extended Stored Procedures" in
BOL.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com

Extended Stored Procedures

The database I am setting up requires a dll file to be added to extended
stored prcoedures - "Using a Microsoft tool such as Enterprise Manager, add
the file to the extended stored prcoedures already installed on SQL Server."
Where/how is this done?
Thank you.
Regards,
DianeYou can run a query like the one below from Query Analyzer. See the Books
Online for more information.
EXEC sp_addextendedproc 'MyFunction', 'MyApp.dll'
Hope this helps.
Dan Guzman
SQL Server MVP
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:508ECDA1-08D8-4593-BAF8-628108DDFF0B@.microsoft.com...
> The database I am setting up requires a dll file to be added to extended
> stored prcoedures - "Using a Microsoft tool such as Enterprise Manager,
> add
> the file to the extended stored prcoedures already installed on SQL
> Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane|||Diane wrote:
> The database I am setting up requires a dll file to be added to
> extended stored prcoedures - "Using a Microsoft tool such as
> Enterprise Manager, add the file to the extended stored prcoedures
> already installed on SQL Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane
See "sp_addextendedproc" and "Creating Extended Stored Procedures" in
BOL.
David Gugick
Quest Software
www.imceda.com
www.quest.com

Extended Stored Procedures

The database I am setting up requires a dll file to be added to extended
stored prcoedures - "Using a Microsoft tool such as Enterprise Manager, add
the file to the extended stored prcoedures already installed on SQL Server."
Where/how is this done?
Thank you.
Regards,
Diane
You can run a query like the one below from Query Analyzer. See the Books
Online for more information.
EXEC sp_addextendedproc 'MyFunction', 'MyApp.dll'
Hope this helps.
Dan Guzman
SQL Server MVP
"Diane" <Diane@.discussions.microsoft.com> wrote in message
news:508ECDA1-08D8-4593-BAF8-628108DDFF0B@.microsoft.com...
> The database I am setting up requires a dll file to be added to extended
> stored prcoedures - "Using a Microsoft tool such as Enterprise Manager,
> add
> the file to the extended stored prcoedures already installed on SQL
> Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane
|||Diane wrote:
> The database I am setting up requires a dll file to be added to
> extended stored prcoedures - "Using a Microsoft tool such as
> Enterprise Manager, add the file to the extended stored prcoedures
> already installed on SQL Server."
> Where/how is this done?
> Thank you.
> Regards,
> Diane
See "sp_addextendedproc" and "Creating Extended Stored Procedures" in
BOL.
David Gugick
Quest Software
www.imceda.com
www.quest.com
sql

Express Manager download for RTM version of SQLServer Express

Has MS updated the Express Manager tool for the RTM version of SQLServer Express? It's a great tool and not having it causes so much pain (I have to use the command line tools!).

Thanks in advance!We're working on an update to the Express Manager. We expect to release a Community Technology Preview of it by the end of the year. In the mean time your options are to use the command line tools, use Visual Studio, or acquire the Developer or Evaluation Editions of SQL Server 2005 and use the full-blown Management Studio.

Dan|||I tried to install the client tools from SQL Server 2005 developer edition but the installer for this (after downloading another 2.8GB!) says components are already installed and cannot be upgraded (or message similar to this).

I'll use the command line tools I guess

Thanks anyways!

Exporting to word or RTF

Is there a way to export to word or at least RTF format?
I was using another reporting tool which can export to RTF, so my clients
are used to export their reports to RTF and they want to keep that feature
but i havent been able to find a way for them to do it.Microsoft doesn't have an RTF or Word renderer in the current release (but
there may be other companies selling their own Reporting Services renderers
that might provide one).
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Rodrigo Sánchez" <rodrigoss@.netshoreprogramming.com> wrote in message
news:O1fVF6FkEHA.3160@.TK2MSFTNGP10.phx.gbl...
> Is there a way to export to word or at least RTF format?
> I was using another reporting tool which can export to RTF, so my clients
> are used to export their reports to RTF and they want to keep that feature
> but i havent been able to find a way for them to do it.
>|||Do you know of a company selling that kind of extension?
Its really difficult to undestand why didnt microsoft included an export to
word filter to my costumers
"Chris Hays [MSFT]" <chays@.online.microsoft.com> escribió en el mensaje
news:eoTkfbGkEHA.3160@.TK2MSFTNGP10.phx.gbl...
> Microsoft doesn't have an RTF or Word renderer in the current release (but
> there may be other companies selling their own Reporting Services
renderers
> that might provide one).
> --
> This post is provided 'AS IS' with no warranties, and confers no rights.
All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No
user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach
of
> children under 3.
> "Rodrigo Sánchez" <rodrigoss@.netshoreprogramming.com> wrote in message
> news:O1fVF6FkEHA.3160@.TK2MSFTNGP10.phx.gbl...
> > Is there a way to export to word or at least RTF format?
> > I was using another reporting tool which can export to RTF, so my
clients
> > are used to export their reports to RTF and they want to keep that
feature
> > but i havent been able to find a way for them to do it.
> >
> >
>|||I am new to Reporting Services and have not actually started to use it yet, since I have a similar requirement in that I need to include RTF reporting. We currently allow storing of data in RTF into our sql database. Our current reports are developed using MsAccess, with an added ocx control, FMS Access Memo Control, to allow for reporting of RTF data. It seems to me that the current version of Reporting Services does NOT allow for reporting of RTF or to RTF. Hopefully the next version will be better,
good luck, and if you can offer any advice/suggestions that you have come across, it would be appreciated.
Sandra
>--Original Message--
>Do you know of a company selling that kind of extension?
>Its really difficult to undestand why didnt microsoft included an export to
>word filter to my costumers
>"Chris Hays [MSFT]" <chays@.online.microsoft.com> escribi=F3 en el mensaje
>news:eoTkfbGkEHA.3160@.TK2MSFTNGP10.phx.gbl...
>> Microsoft doesn't have an RTF or Word renderer in the current release (but
>> there may be other companies selling their own Reporting Services
>renderers
>> that might provide one).
>> -- >> This post is provided 'AS IS' with no warranties, and confers no rights.
>All
>> rights reserved. Some assembly required. Batteries not included. Your
>> mileage may vary. Objects in mirror may be closer than they appear. No
>user
>> serviceable parts inside. Opening cover voids warranty. Keep out of reach
>of
>> children under 3.
>> "Rodrigo S=E1nchez" <rodrigoss@.netshoreprogramming.com> wrote in message
>> news:O1fVF6FkEHA.3160@.TK2MSFTNGP10.phx.gbl...
>> > Is there a way to export to word or at least RTF format?
>> > I was using another reporting tool which can export to RTF, so my
>clients
>> > are used to export their reports to RTF and they want to keep that
>feature
>> > but i havent been able to find a way for them to do it.
>> >
>> >
>>
>
>.
>

Exporting to textfiles

Hi,
I have a SQL 2000 db with 140 tables. I want to export all tables to
textfiles. If I use Tool | Export data I only can export one table each
time.
Is there any way to export all tables automatically (I want the resulting
textfiles to have the same name as the original db table)?
Regards
PO
Hi,
You can write a BCP OUT command for Information_schema.Tables
Execute the below script in Query analyzer with Text result. Paste the
output of the result in a new Query window and execute. This will export the
table data to text files in c:\backup folder with the table name as the text
file name.
use <dbname>
go
set quoted_identifier off
select 'master..xp_cmdshell '+"'"+bcp pay..'+table_name+' out
c:\backup\'+table_name+'.txt -Usa -Phari -Sa266uss\harisql -c'+"'"
+char(10)+'go' from information_schema.tables where +table_type='BASE TABLE'
Thanks
Hari
MCDBA
"PO" <po> wrote in message news:e1$nZ0YaEHA.1048@.tk2msftngp13.phx.gbl...
> Hi,
> I have a SQL 2000 db with 140 tables. I want to export all tables to
> textfiles. If I use Tool | Export data I only can export one table each
> time.
> Is there any way to export all tables automatically (I want the resulting
> textfiles to have the same name as the original db table)?
> Regards
> PO
>

Exporting to Access

How do you export data from sql server to Access ? Try
DTS export wizard tool available from sql server
enterprise Manager. It will let you delete all rows from
Access tables and then load data from sql to access. You
can also save the export options in a DTS package which
you can simply execute next time when you need to export
data. You can also schedule it to run on regular interval.
You can find more details about DTS packages in sql server
BOL, or post specific questions here.
hth.

>--Original Message--
>Hello, I occasionally have to take all the tables from a
particular
>database and dump the data into Access tables. When I
use the wizard to do
>this, I find that the tables in access must be empty
prior to me stepping
>through the wizard to export the data or otheriwse is
kick the transaction
>out as duplicate. I have been going into access and
running a query for
>each of the tables to delete all of the data.
>Is there a way that I can do this all within SQL? Can I
write the commands
>to initialize those tables in access in some sort of SQL
Proc?
>Your suggestions would be greatly appreciated!!!!!!!!!
>.
>Thanks

Exporting sql tables and data to T-SQL statements

Is there any tool, either built into MSSQL or a 3rd party, that allows
me to export any SQL table and its data to T-SQL statements?
Thank you
shija03@.hotmail.com wrote:
> Is there any tool, either built into MSSQL or a 3rd party, that allows
> me to export any SQL table and its data to T-SQL statements?
> Thank you
This feature is a part of Toad for SQL Server from Quest Software.
David Gugick - SQL Server MVP
Quest Software
|||<shija03@.hotmail.com> wrote in message
news:1140116013.437263.296310@.g44g2000cwa.googlegr oups.com...
> Is there any tool, either built into MSSQL or a 3rd party, that allows
> me to export any SQL table and its data to T-SQL statements?
> Thank you
>
Is this something that you are looking for?
http://vyaskn.tripod.com/code/generate_inserts.txt
Rick Sawtell
MCT, MCSD, MCDBA
|||Some options mentioned here: http://www.karaszi.com/SQLServer/inf...ate_script.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<shija03@.hotmail.com> wrote in message news:1140116013.437263.296310@.g44g2000cwa.googlegr oups.com...
> Is there any tool, either built into MSSQL or a 3rd party, that allows
> me to export any SQL table and its data to T-SQL statements?
> Thank you
>

Exporting sql tables and data to T-SQL statements

Is there any tool, either built into MSSQL or a 3rd party, that allows
me to export any SQL table and its data to T-SQL statements?
Thank youshija03@.hotmail.com wrote:
> Is there any tool, either built into MSSQL or a 3rd party, that allows
> me to export any SQL table and its data to T-SQL statements?
> Thank you
This feature is a part of Toad for SQL Server from Quest Software.
--
David Gugick - SQL Server MVP
Quest Software|||<shija03@.hotmail.com> wrote in message
news:1140116013.437263.296310@.g44g2000cwa.googlegroups.com...
> Is there any tool, either built into MSSQL or a 3rd party, that allows
> me to export any SQL table and its data to T-SQL statements?
> Thank you
>
Is this something that you are looking for?
http://vyaskn.tripod.com/code/generate_inserts.txt
Rick Sawtell
MCT, MCSD, MCDBA|||Some options mentioned here: http://www.karaszi.com/SQLServer/info_generate_script.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<shija03@.hotmail.com> wrote in message news:1140116013.437263.296310@.g44g2000cwa.googlegroups.com...
> Is there any tool, either built into MSSQL or a 3rd party, that allows
> me to export any SQL table and its data to T-SQL statements?
> Thank you
>

Exporting sql tables and data to T-SQL statements

Is there any tool, either built into MSSQL or a 3rd party, that allows
me to export any SQL table and its data to T-SQL statements?
Thank youshija03@.hotmail.com wrote:
> Is there any tool, either built into MSSQL or a 3rd party, that allows
> me to export any SQL table and its data to T-SQL statements?
> Thank you
This feature is a part of Toad for SQL Server from Quest Software.
David Gugick - SQL Server MVP
Quest Software|||<shija03@.hotmail.com> wrote in message
news:1140116013.437263.296310@.g44g2000cwa.googlegroups.com...
> Is there any tool, either built into MSSQL or a 3rd party, that allows
> me to export any SQL table and its data to T-SQL statements?
> Thank you
>
Is this something that you are looking for?
http://vyaskn.tripod.com/code/generate_inserts.txt
Rick Sawtell
MCT, MCSD, MCDBA|||Some options mentioned here: http://www.karaszi.com/SQLServer/in...ipt
.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<shija03@.hotmail.com> wrote in message news:1140116013.437263.296310@.g44g2000cwa.googlegroup
s.com...
> Is there any tool, either built into MSSQL or a 3rd party, that allows
> me to export any SQL table and its data to T-SQL statements?
> Thank you
>

exporting SQL data as Access readable file

hi guys.
i'm looking to try and get a web tool together that will basically allow a user to download a file that can be plopped into MS Access, using the data i have on my servers stored in MS SQL Server...
any ideas?nobody, huh?|||bcp out a data file?

You need to be clearer on your process and what you're trying to do..

I'd venture to say that a stored procedure will be called, then using xp_cmdshell bcp out a view or use queryout...

But a little more explination would help us...