Script out table data 2

[hapax]

How can I script out the contents of a table - all the data in all the rows?

I'm looking for results similar to what the Database Publishing Wizard produces, but I only need to copy one table not the whole database.

I want to recreate a table on a second database. I want to automatically create the SQL that I can run to fill in the same data as the other table, assuming I've already created the table.

 

[gmmastros]

I recommend BCP. It's the absolute fastest way to export and import data.

http://blogs.techrepublic.com.com/datacenter/?p=319

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[gmmastros]

For other methods.....

http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/title-12

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

Check also this great blog by Brad Schultz to produce your scripts

http://bradsruminations.blogspot.com/2009/07/uspcreateandinsert.html

 

[markros]

Sorry, I meant Brad Schulz (no t in last name).