DB Change Manager

Track and Manage Complex Database Schema Changes

  • Quickly roll out and reconcile database changes
  • Reveal, track, and report on database changes
  • Comply with database audit and reporting requirements
  • Protect data privacy within the database environment
  • Track changes from multiple major database platforms

 

Category:

Easily Manage Database Changes

Use a live-to-live database compare to obtain a list of changed objects, and generate an alter script to synchronize selected objects. Capture a snapshot of the target before applying changes, so that you can roll back a schema change if necessary. Automatically synchronize the target to match the source once there is a successful comparison.

Track & Report on Changes

Reveal and report on changes to packaged application databases resulting from vendor patches or customization. Uncover database abnormalities stemming from improper changes, which might impact production performance or functionality. Notify yourself or others when a particular portion of the database has changed.

Comply with Audit Requirements

Identify and report on changes to the database at or between points in time, or to particular sensitive objects, ad hoc or on a regular basis. Use custom or live configurations to create security and performance standards. Audit database configurations against established standards to minimize vulnerability.

Secure Data Privacy

Ensure that pre-production databases are accurately tested while protecting sensitive information. Protect sensitive data in the production environment with data masking, and quickly migrate the masked, yet realistic and fully functional, data into Development, Test and QA environments.

Track Changes Across Platforms

DB Change Manager offers multi-database platform support for major DBMSs from a single interface. This capability expedites system access and translates DBA skills across platforms to reduce learning curves and errors. DB Change Manager includes support for Oracle, SQL Server, DB2 and Sybase.

 

 

Download the Datasheet, or find out pricing by clicking the Contact Us button.

 

 

Product Tour

Easily Manage Database Changes

DB Change Manager puts the power of change tracking, schema comparison, software-generated synchronisation scripts, and flexible reporting into the hands of DBAs and developers. Use synchronisation and rollback to easily generate alter scripts to sync selected objects or restore databases to a secure point in time. Identify and report on changes to the database at or between points in time. Get proactive notifications of overnight changes to simplify troubleshooting.

Perform Schema Comparison

Use DB Change Manager to identify and address potential issues in database schema. Schema compare capability helps you locate unanticipated problems immediately. Map the databases and schemas to pair the source and target databases for comparison. Use a live-to-live database compare to obtain a list of changed objects. First select which databases to compare, then proceed to refine the comparison parameters.

 

Set Comparison Filters

Refine your schema comparison using filters for owner, object, and type, to select the source items to compare against the target. This allows you to control the size and scope of the compare operation and its output. After that, specify object options and settings, choose manual or automatic synchronisation, run the comparison, and review the list of results and reports generated.

 

View Alter Code

In the schema comparison detail report, see the SQL code required to implement the changes between schema archives, live data sources or both. DDL differences are colour-coded for easy comparison. Promote schema changes from Development, to Test and finally to Production.

 

Protect Data Privacy

Shuffle or randomise columns in a data compare with an auto-synchronisation job. De-identify data in the production environment and quickly migrate the masked, yet realistic and fully functional, data into Development, Test and QA environments.

 

 

 GET IN TOUCH

For a more detailed discussion about how DB Change Manager might meet your needs, fill out the contact form and we’ll follow up with you.