Page History
DB Change Manager provides features to help you manage databases from development to deployment and maintenance cycles. These features include:
- Data Comparison and Synchronization
- Schema Comparison and Synchronization
- Database Configuration Management
- Reports, Notifications, and Change History
- Data Masking
- Source Control System Integration
Table of Contents | ||||
---|---|---|---|---|
|
Data comparison and synchronization
...
- Keeping primary and backup data in sync
- Keeping up with data changes during the development and testing cycles, and later on to deployment environments
- Managing data migrations during upgrade activities
Schema Comparison and Synchronization
DB Change Manager can capture and compare the database schema in your enterprise. Over the lifecycle of a single schema, you can capture a baseline or archive schema and analyze changes through time. In addition, DB Change Manager generates a SQL script that can update a target schema so that it matches a standard. You can modify the SQL and execute it as needed.For more information, see the video demos Schema Compare with Auto-Synchronization and Cross-DBMS Schema Compare. The demos were made for a previous release and are still relevant.
Database Configuration Management
In addition to schema, there are configuration settings that can vary across an enterprise. DB Change Manager can capture the configuration settings of a data source. You can capture a baseline or archive configuration and analyze changes through time. You can create a configuration standard that defines the norms for your enterprise and against which you can compare your databases.For more information, see the video demo Monitoring for Change. The demo was made for a previous release and is still relevant.
Reports, Notifications, and Change History
DB Change Manager supports your data management activities with notifications when processes execute, reports that capture key information, and change history tracking.For more information, see the video demo Monitoring for Change.
Data Masking
There are specific scenarios when you need to hide the true values of the data in a database. For example, during development you need to protect personal or proprietary data, yet you still need to work with data that accurately represents the source. By combining data synchronization with data masking features, such as randomization or shuffling, you can duplicate source data and use the masked copies in non-production or non-secure environments.For more information, see the video demo Data Masking. The demo was made for a previous release and is still relevant
Source Control System Integration
You can integrate DB Change Manager with source control systems such as Concurrent Versions System (CVS), Visual Source Safe (VSS), or Eclipse plugins. The Navigator in DB Change Manager is the interface for accessing files under source control. Job files and archive versions are stored as XML files and synchronization scripts are stored as text files. You perform all source code control actions using the source control system.For more information, see the video demo Developer Versioning Database and Code. The demo was made for a previous release and is still relevant