Posted by George Shubin on 11/21/06 18:39

Using SQL Server 2005 Express.

I need to periodically duplicate an entire database and rename it. Most
tables are empty but some are to be prepopulated. I was thinking of having
a "template" database called perhaps "EmptyDatabase", and then copy that
into a freshly created database with a new name.

Has anyone coded anything like this?

Thanks.

GS

• Next in forum: Re: Default Table Owner using CREATE TABLE, INSERT, SELECT & DROP TABLE
• Prev in forum: Re: case insensitive
• Thread view: Database Cloning

[Reply to this message]