James Barash
James at fcidms.com
Tue Mar 25 13:40:23 CDT 2008
John: If you only need to copy the design of the database but not the data, you can use the scripting wizard to create a script of all the objects and use that to make the new database. If you are using SQL Server 2005, Right-Click on the database, select Tasks -> Generate Scripts. Then you can choose to script all the objects, including Tables, Views, Stored Procedures, UDF, Users, etc; or you can choose individual objects. Once you've created the script, add the appropriate Create Database statement at the top and save the script to a file and you will be able to build as many database as you need from the same template. Hope this helps. James Barash -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Tuesday, March 25, 2008 2:06 PM To: 'Discussion concerning MS SQL Server' Subject: [dba-SQLServer] Copy a database using a store procedure or function I have built up a template database which has views that pull data out of many different databases / tables. Additionally I now have user stored procedures which perform processing steps. In real life I manually copy this template database to a new name using the copy database wizard, and then run the stored procedures and stuff to build up a data order for shipment. What I really need to do is have a method of copying this database to a new name and then "use" that database to launch the various stored procedures inside of it to fill the tables, build the data and export the data. Is there a function or sp which can copy a database to a new name? When I Google I get about a million "use the copy database wizard" answers. John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com