REQ: SSMS Add-in create snapshot

• 
  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 January 20, 2011 13:22

  - 0 +
• 
  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

  tkdennis January 21, 2011 13:32

  - 0 +
• 
  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 January 21, 2011 20:07

  - 0 +

Add comment

Please sign in to leave a comment.