[dba-SQLServer] Copy database question

Steve Conklin (Developer@UltraDNT) Developer at UltraDNT.com
Wed Nov 24 12:24:10 CST 2004


In Ent. Mgr. 2000, right click the source database, then "All Tasks"
then "Generate SQL Script."  Run the resulting script in QA in the
target database.

Hth
Steve


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Wednesday, November 24, 2004 12:53 PM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Copy database question


I want to copy a database containing 100+ tables, about 500 sprocs and 
about 200 views and about 20 UDFs to a new database, but with the 
proviso that no data goes, only the structures. I'm not sure how to do 
this. Suggestions?

TIA,
A.

>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.4.1 - Release Date: 11/19/2004

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list