SQL change manager

With SQL change manager you can implement a Management Plan to automatically capture snapshots of database schemas on a regular basis, or take snapshots on an ad-hoc basis as needed. Database snapshots are stored in an efficient, compact format and can be kept for long periods of time in the SQL change manager repository. Using this comprehensive version history, you can:

• Report on databases that are inconsistent with a standard, baseline schema
• Highlight what specific changes have been made to a schema between any two snapshots
• Roll back to any previous version of a database schema

With SQL change manager you can automate implementing even complex changes in your SQL Server databases. SQL change manager lets you automatically:

• Roll out schema changes to existing databases
• Replace objects in one database with objects from another database
• Add objects to one or multiple databases
• Create multiple new databases based on a standard schema

Even the best thought out change can have unintended consequences. When erroneous schema changes must be undone, DBAs need to have the ability to quickly revert to a previous schema version, or repair specific database objects. With SQL change manager, DBAs can:

• Roll back a database schema to a previous version using a schema snapshot or another database as a source
• Restore lost or damaged objects from a snapshot or another database