Easier Method to Snapshot Multiple Databases from same server(s)
1) SQL Compare has handy database snapshot ability to a folder. It would be great if rather than creating 1 database snapshot at a time you could tick each of the databases you'd like a snapshot created for.
2) Would be cool if like SQL Multiscript tool, you can speficity multiple servers and databases and have the snapshots named and/or placed in folders with server and database names.
3
votes
T
shared this idea
-
T
commented
To make a copy of all the database schemas on a server at one time which can be reviewed as necessary offline without access to the server.
-
@T - What are you using the snapshots for? To understand how best to solve this problem, we would need some context about your scenario.
