For Database Administrators

Roll out database changes more easily

• Use 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

Easily reveal how a database has changed since a point in time and track and report on changes

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

For Developers, Development Managers and QA

Use DB Change Manager XE2 to help streamline and accelerate your development cycles

• Track and communicate database changes with modelers, DBAs, and other developers
• Integrates with source code control (SCC) software to correlate schema change with application code changes by linking an archive with version of the application within the SCC repository
• Archive modified stored procedures, tables, indexes, etc., and report on the modifications using the scheme compare functionality
• Associate a change request with a set of database objects that have changed
• Manage your reference data via live-to-live data compare, and report on reference data changes

• Ensure the integrity of your structures and reference data before you begin testing
• Ensure that development and QA match production: that no changes to production have occurred that would otherwise escape your attention

Streamline common development and QA tasks

• Easily generate change scripts, for changes to modified schema and dependent objects
• Capture your database objects at points in time, so that you can report on, or roll back to a particular state in time for just that object, or for an entire schema
• Use data compare as a basis for comparing expected to actual results
• Manage your reference data