March 30, 2006 at 2:15 pm
Is it possible to script a Table with its contents to a file? Such that if you execute the script in a different DB it creates the Table and inserts all its original contents. How would you do that?
March 31, 2006 at 6:20 am
you'll need to do it in a DTS package using using the copy object task.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
March 31, 2006 at 9:01 am
The DTS copy object task will not do what you've asked.
Try this script:
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1642
It was posted to sqlservercentral 2 days ago.
It has some conditions that may prevent it from working for you. You may also want to google for
MSSQL insert script generator
There are plenty of tools listed by that particular search. Good luck!
jg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply