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-
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:
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
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
4 matches
Mail list logo