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.
Does such a “quick clone” function exist or could I implement one by myself (or maybe through some add-in?)
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?
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?
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.