xSQL Object & xSQL Data Compare

Schema Snapshots

 

You can track the database schema changes by taking regular “snapshots” of the database schema. Comparing a live database with snapshots taken at different times will give you a clear picture of the “evolution” of that database schema.

Also, it is sometimes necessary to reverse the changes that may have been made on a database – the schema snapshots will allow you to quickly and efficiently achieve just that.

To take a snapshot of a database click on “Save Database” under the Edit menu – you will be prompted to select the database the snapshot of which you would like to take. You can also take a snapshot of a database by right clicking on the the name of the database on the SQL Servers panel and then selecting "Save Snapshot".

Important: while you can rely on a schema snapshot to reverse schema changes note that the snapshot does not store any data so if during the schema changes any data was lost because let's say a column was dropped you will be able to bring back that column but not the data that was in it. You will need to restore the data from a regular SQL Server backup.