DB Change Manager

Quickly Roll-out database changes

Ensure database synchronization by using a live-to-live database compare as a basis for obtaining a list of changed objects, and a change script to roll the changes forward. Capture a snapshot of the target before you roll changes forward, so that you can roll back a schema change if necessary. Deep support for DB2 for LUW, Oracle, SQL Server and Sybase leverages DBMS-specific features, objects, options, and syntax.

Reveal, Track and Report how a database has changed

Reveal and report on changes to packaged application databases resulting from vendor patches or customization. Uncover abnormalities in the database that result from improper change, which might impact production performance or functionality. Notify yourself or your colleagues when a particular portion of the database has changed: for example tables for data modelers, stored procedures for developers, etc.

Comply with Database Audit and Reporting 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. Audit database configurations against established standards to minimize the vulnerability of your databases.

Protect Data Privacy

Shuffle or randomize columns in a data compare with an auto-synchronization 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.

Mitigate Organizational Risk, Align with Data Governance Principles

DB Change Manager's ability for database synchronization and capability to identify and report on changes to the database between points in time both help organizations comply with database audit and reporting requirements. Organizations can protect data privacy with data masking and mitigate organizational risk by using DB Change Manager to reveal, report, and notify changes to critical databases configurations. DBAs can also restore databases to a secure point in time with DB Change Manager's alter scripts.

System Requirements

Minimum hardware requirements

• Pentium 4-level processor
• 1 GB of Memory
• 1 GB of free disk space
• 1024 x 768 display

Change Manager supports the following operating systems:

• Windows 7 (x86-32, Win32)
• Windows Server 2008 (x86-32, Win32)
• Windows XP (x86-32, Win32)
• Windows Vista (x86-32, Win32)
• Windows Server 2003

DB Change Manager Product Editions

DB Change Manager is available in three editions – Developer, Professional, and Enterprise editions, all of which have platform-specific and XE versions.

Developer Edition – Designed for the database developer, this edition allows basic schema and data comparisons, but is limited in its number of datasource connections. This edition also does not have additional notification, auditing, or privacy capabilities.

Professional and Enterprise Editions – Designed for the database administrator that require comprehensive schema and data comparison capabilities as well as functionality to notify, audit, and secure data privacy. The Enterprise edition contains a Command-line API for job scheduling. There are no datasource limitations in Professional and Enterprise editions.

* Change Manager XE is available in Developer, Professional, and Enterprise editions

Platform-specific Versions – These products support one major platform. DB Change Manager for Oracle, DB Change Manager for SQL Server, DB Change Manager for Sybase, and DB Change Manager for DB2 are available.

XE Version – Grants the license holder the ability to connect to multiple supported database platforms within the same User Interface, with no need to purchase additional platform-specific software. These users can connect to Oracle, SQL Server, Sybase, and DB2 (LUW & z/OS) platforms simultaneously.