By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,640 Members | 1,363 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,640 IT Pros & Developers. It's quick & easy.

Duplicating a SQL Server database from .Net

P: n/a
RSH
I have a situation where I have almost 100 databases that when we get a new
client we need to 'copy' the template databases and rename them and I would
like to be able to write a VB .Net application to quickly make copies of the
databases and then transfer the data to the new databases.

I have the data transfer script written, i just need some way of copying the
databases one at a time with all of the table structures and renaming the
database using .Net

How would I go about doing this? Is there a SQL command that would aid in
this? Does anyone have any examples or articles on how to do this?

Thanks!
RSH
Nov 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Your best bet is posting to a SQL Server newsgroup.

--
Jonathan Allen
"RSH" <wa*************@yahoo.com> wrote in message
news:ev**************@TK2MSFTNGP14.phx.gbl...
I have a situation where I have almost 100 databases that when we get a new
client we need to 'copy' the template databases and rename them and I would
like to be able to write a VB .Net application to quickly make copies of
the databases and then transfer the data to the new databases.

I have the data transfer script written, i just need some way of copying
the databases one at a time with all of the table structures and renaming
the database using .Net

How would I go about doing this? Is there a SQL command that would aid in
this? Does anyone have any examples or articles on how to do this?

Thanks!
RSH

Nov 21 '05 #2

P: n/a
You should look into using DTS. You can setup the jobs, save them and run
them on a schedule or manually. You could run scripts of the structure of
the databases and then when that is complete, have it do a data copy. You
could even include security accounts if it is going to a different server.

Shawn

"RSH" <wa*************@yahoo.com> wrote in message
news:ev**************@TK2MSFTNGP14.phx.gbl...
I have a situation where I have almost 100 databases that when we get a new
client we need to 'copy' the template databases and rename them and I would
like to be able to write a VB .Net application to quickly make copies of
the databases and then transfer the data to the new databases.

I have the data transfer script written, i just need some way of copying
the databases one at a time with all of the table structures and renaming
the database using .Net

How would I go about doing this? Is there a SQL command that would aid in
this? Does anyone have any examples or articles on how to do this?

Thanks!
RSH

Nov 21 '05 #3

P: n/a
Hi,

http://www.microsoft.com/downloads/d...DisplayLang=en

Ken
------------------------
"RSH" <wa*************@yahoo.com> wrote in message
news:ev**************@TK2MSFTNGP14.phx.gbl...
I have a situation where I have almost 100 databases that when we get a new
client we need to 'copy' the template databases and rename them and I would
like to be able to write a VB .Net application to quickly make copies of the
databases and then transfer the data to the new databases.

I have the data transfer script written, i just need some way of copying the
databases one at a time with all of the table structures and renaming the
database using .Net

How would I go about doing this? Is there a SQL command that would aid in
this? Does anyone have any examples or articles on how to do this?

Thanks!
RSH

Nov 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.