sql server new users: Using SQL Server 2005 Dev and SQL Server Manager, how do I dump a table and
it's data to a file then import it into another table?

I see the options "Script Table as" and then the Create To, Drop To, etc.
options, but all of those only put the structure in the file. What am I
missing?

Thanks.

Check out bcp.exe in the BOL.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


[quoted text, click to view]
Using SQL Server 2005 Dev and SQL Server Manager, how do I dump a table and
it's data to a file then import it into another table?

I see the options "Script Table as" and then the Create To, Drop To, etc.
options, but all of those only put the structure in the file. What am I
missing?

Thanks.

Alternatively, open up Management Studio and connect to your instance.

Go to that database which stores your tables and right click on that
database. You'll see Tasks and Import and Export in that menu.

You can use these stuff to import into your tables and export from them.

P.S.
If you want to export to a file, then use Flat File as detination.

--
Ekrem Önsoy
http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCBMSP, MCT



[quoted text, click to view]