REQ: SSMS Add-in create snapshot

tkdennis

In the SSMS Add-in, i would be nice to have the option to create a database snapshot.

David Atkinson

Could you explain why this would be useful from SSMS? Understanding the use case would help us consider this as a feature.

Thanks,

David Atkinson
Red Gate Software

tkdennis

I like to take snapshots of my database schema before executing DML scripts or restoring backups so I can verify what changed and restore schemas if needed. It would be very convenient to do it right from SSMS with the Server and Database name already plugged in instead of switching to SQL Compare, clicking create snapshot and typing them in.

Thanks,
Traci

David Atkinson

Presumably you mean 'DDL' rather than 'DML'?

We're actually contemplating a feature that would allow database changes to be undone. This would work by effectively keeping a snapshot of your schema each time a schema change is detected. You would be able to view a historical timeline of all schema changes made to your database, and consequently allow you to revert back to any one you like.

Is this a feature that you (or anyone else reading this thread) would find useful?

David