Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Script out table data 2

Status
Not open for further replies.

hapax

Programmer
Joined
Nov 10, 2006
Messages
105
Location
US
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.
 
Sorry, I meant Brad Schulz (no t in last name).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top