[dba-SQLServer] Copy a database using a store procedure or function

jwcolby jwcolby at colbyconsulting.com
Tue Mar 25 13:05:32 CDT 2008


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 




More information about the dba-SQLServer mailing list