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?