How to transfer database to text file - and from text file to database in SQL Server 2008

Question

I try something like: select * into 'd:\test.txt' from men

but it doesn't work.

Dani · Accepted Answer · 2011-01-07 10:49:14Z

1

A. better use backup to do it.

B. There are tools that generate a "create" script for an entire database (like TOAD in commercial version).

What exactly are you trying to achieve ?

If you want to code this - you can select the table into a data reader, and then for each row append it to a text file.

answered Jan 7, 2011 at 10:49

Dani

15.1k12 gold badges69 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Taneli Waltari · Accepted Answer · 2011-01-07 11:02:27Z

0

SQL Server Management Studio: "Tasks -> Back Up" or "Tasks -> Generate Scripts" or "Tasks -> Export -> Flat file destination".

Alternatively you could use the bcp.exe command line tool.

answered Jan 7, 2011 at 11:02

Taneli Waltari

6873 silver badges5 bronze badges

i need it in query solution not in the sql-server backup or similar tool.