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.
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.