RE: TSQL Script to replicate a db?

2003-03-18 Thread Jason Lees (National Express)
You could use the Scripting wizard in the Enterprise manager. To do this Select the DB right click, and select Script DB, this gives you the necessary wizard to get everything, SP's, tables, Indexes etc. Jason Lees Development Team Leader National Express Systems. -Original Message-

RE: TSQL Script to replicate a db?

2003-03-18 Thread Janine Jakim
Save as a dts package and then you can edit the information. They have a visual interface- add dependencies/etc. I suggest making some db copies and play with it -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 9:47 AM To: CF-Talk Subject:

RE: TSQL Script to replicate a db?

2003-03-18 Thread Dowdell, Jason G
Very cool, thanks. ~Jason -Original Message- From: Jason Lees (National Express) [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 10:12 AM To: CF-Talk Subject: RE: TSQL Script to replicate a db? You could use the Scripting wizard in the Enterprise manager. To do this Select

RE: TSQL Script to replicate a db?

2003-03-18 Thread Cantrell, Adam
When exporting to the other database, instead of using: Copy tables and views from the source database try using: Copy objects and data between SQL Server databases Adam. -Original Message- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 8:47 AM