DB Change Manager

Overview
Details
Tec Specs
Resources
Tour
Download

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 & Synchronization

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.

System Requirements

Minimum Hardware Requirements:

1 GHz or faster CPU
3 GB of RAM
1 GB of free disk space
1024 x 768 display

Supported Operating Systems:

Windows 10, Windows 8.1, Windows 8, Windows 7 (32- and 64-bit)
Windows Server 2008 SP1 & 2008 R2 (32- and 64-bit)
Windows Server 2012 & 2012 R2
Windows Server 2016

Supported Database Platforms:

Microsoft SQL Server 2008, 2012*, 2014*, 2016*, 2017*
Microsoft SQL Server 2019* (experimental support)
Oracle 10g*, 11g*, 12c*, 18c*, 19c*
Sybase ASE 15.x and 16.x*
IBM Db2 LUW 10.x and 11.x*

Cloud

DB Change manager runs on cloud virtual machines (such as Microsoft Azure VM and AWS EC2) with Microsoft Windows. It supports database instances on cloud virtual machines (such as Microsoft Azure VM and AWS EC2).

*For these databases, DB Change Manager supports a subset of this database version’s features/functions.

Version History

Version 17.0.4

SQL Server 2019 (experimental support), Oracle 18c and 19c database support
Bug fixes

Version 17.0.3

Sybase 16.0 database support
Bug fixes

Version 17.0

SQL Server 2017 database and Windows Server 2016 OS support
Versionless licensing for easier upgrades
Bug fixes, including fix for null pointer errors on shutdown
.msi version available for UI-free “headless” installation
Removal of support for Firebird and InterBase platforms

Version 16.6

Platform support for Db2 for LUW v11 and Sybase 16.x
Updated installer to improve product installation experience

Version 16.5

DB Change Manager now has a single edition that includes all available features and has been rebranded for IDERA.
Now available in both 32-bit and 64-bit versions
Platform updates:
- Supported Operating Systems: Windows 10, Windows Server 2012 & 2012 R2
- Supported Database Platform: Microsoft SQL Server 2016
- Installation Platforms: Java 8 and Eclipse 4.5.2

Version 6.3

Support now available for the following DBMS versions:

Oracle 12c
Microsoft SQL Server 2012
Sybase ASE 15.0.3, 15.5, and 15.7

OS support added for the Microsoft Windows 8 platform
Upgrades to platforms:

Java 7
Eclipse 3.8.2

DB Change Manager Datasheet

Everything you need you need to know, all in one downloadable PDF.

DOWNLOAD THE DATASHEET

The Word on the Streets

See what our customers say about DB Change Manager.

DOWNLOAD THE CASE STUDY

View a Democast

Let a pro show you some tips and tricks, live and free!

DB Change Manager Product Tour

Easily Manage Database Changes: DB Change Manager puts the power of change tracking, schema comparison, software-generated synchronization scripts, and flexible reporting into the hands of DBAs and developers. Use synchronization 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.

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 color-coded for easy comparison. Promote schema changes from Development, to Test and finally to Production.

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 synchronization, run the comparison, and review the list of results and reports generated.

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.

Track and Manage Complex Database Schema Changes

Download DB Change Manager Today!

Simplify change operations with compare and synchronization capabilities.

Fully functional for 14 days. No credit card required (but all fields are).

Overview

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