12c

  • 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

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.

Compare & Synchonization

Schema Archive and Compare
Capture and compare schema differences between one or more archived or live databases.
Synchronization and Roll-back
Generate alter scripts to sync selected objects or restore to a prior state. Handles object dependencies, and preserves data.
Schema Auto-Synchronization
Automatically synchronize the target to match the source once there is a successful comparison. Promote schema changes from development, to test and finally to production.
Data Compare and Synchronization
Compare and synchronize data either inside of one database or between two different databases.
Job Notification
Receive job status notifications via email.
Multi-platform Support
All major DBMSs are supported from a single interface. Ability to use the tools on all supported platforms from a single license.

Security & Compliance

Configuration Standards
Use custom or live configurations to create standards. Audit database configurations to check for security liabilities and performance standards.
Data Masking
Ensure accurate testing while complying with international privacy laws.
Archive Configuration and Schema Settings
Schema and configuration archives provide historical record for compliance auditing and reporting.
Schema Comparison Detail Report
See which objects have actually changed, either between schema archives, live data sources or both. DDL differences are color-coded for easy comparison.

dataapps