REQ: SSMS Add-in create snapshot

tkdennistkdennis Posts: 114
edited January 21, 2011 8:07PM in SQL Compare Previous Versions
In the SSMS Add-in, i would be nice to have the option to create a database snapshot.
· Share on Twitter

Comments

  • David AtkinsonDavid Atkinson Posts: 1,462 Rose Gold 2
    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
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
  • tkdennistkdennis Posts: 114
    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
    · Share on Twitter
  • David AtkinsonDavid Atkinson Posts: 1,462 Rose Gold 2
    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
    David Atkinson
    Product Manager
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.