Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How to generate the script which includes tables

Author  Topic 

reddymade
Posting Yak Master

165 Posts

Posted - 2005-10-19 : 15:35:02
I would like to generate sql script from sql server 2000 via tasks generate script.

I want to generate a script for the whole database with tables and it data in table with Stored proc. etc.

Can you please tell me, i tried using the generate script from tasks, but i don't see the data coming with it. it is only bringing the tables database with tables structure plus stored procs.

Please help, Thank you very much for the information.

Kristen
Test

22859 Posts

Posted - 2005-10-19 : 15:40:25
If you want all the table structure AND the data wouldn't it be easier to just take a BACKUP and RESTORE it on the target machine?

Kristen
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-10-19 : 15:40:58
That is correct, it doesn't give you the data. If you want everything, just use BACKUP/RESTORE method.



Tara
Go to Top of Page
   

- Advertisement -