1

For testing purposes, I often have to clone databases (onto the same server). Currently I do this by creating a backup and restoring it as a new database.

I would love to have such a functionality available as a simple right-click in SQL Server Management Studio (SSMS): right-click a database, choose "Clone" and be done.

Unfortunately I found no such or a similar function in SSMS.

My question:

Does such a "quick clone" function exist or could I implement one by myself (or maybe through some add-in?)

Update 1:

I've found a SO question and answer on using the Copy wizard.

This looks promising but takes a lot of wizard steps. Maybe it is possible to do this whole thing with a single click?

  • 2
    Just use a T-SQL Script in a SQL Agent job. Right-click the job and select run. – Shawn Melton Jan 29 '15 at 20:53
3

I just took a look at my ssms. Copy is in SSMS 2012 and 2014 under tasks. I haven't tried it but it is there. What ssms are you using?

SSMS 64 bit: http://download.microsoft.com/download/5/2/9/529FEF7B-2EFB-439E-A2D1-A1533227CD69/SQLManagementStudio_x64_ENU.exe

1

What about an ssis package? Create an SP that calls an ssis package which copies (clones) a db given two parameters; source db and destination db.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.