Dump SQL Server Database

[Prasad Bandaru]

Hi,

I am wondering if there is any way in SQL Server7.0 to dump all the data in
the database into text file. I tried to use the feature that comes with SQL
server but, using that it would let me dump only one table at a time. I do
not want to use the backup feature as I need to take a look at the data at a
later stage with out using SQL server.

Any help is greatly appreciated.
Thanks a lot in advance
-Prasad

[Nimesh]

You can do this using Data Transmission Services (DTS) from SQL
Server. I don't have an access to sql svr hence, can't tell you
complete instructions, but am sure DTS is quiet simple to use and it
can create csv files of the data for selected tables.

Just be careful, if your data itself contains comma then there might
be confusion while importing it but export will go fine.

- Nimesh

"Prasad Bandaru" <pban...@mediaone.net> wrote in message news:<SOc_6.39317$_Y5.74...@typhoon.ne.mediaone.net>...