Welcome to Change Manager 5.1

Change Manager Web Site | Embarcadero Technologies Home | Technical Support

Last updated: July 17, 2009


Thank you for using Change Manager 5.1. Change Manager provides automation to manual tasks such as database comparisons, difference reporting, and the development of synchronization scripts. Additionally, it provides support for troubleshooting database problems by retaining prior database states and versions in addition to the live source. The application is modularized among data, configuration, and schema comparison which enables you to control aspects of data, configuration parameter, and schema comparisons, respectively.

What's New in Change Manager

Data Masking

Auto-Synchronization for Data Comparison and Schema Comparison Jobs

DBMS Unicode Support

Cross-Platform Support for Schema Comparison Jobs

Project Creation and Management

Job Notification Enhancements

New History Tab on the Data Comparison Job Editor

Enhanced Data Comparison Mapping

Release Notes

System Requirements

Important Advisory Notes

Known Issues

Bug Fixes

Additional Resources

Licensing Your Embarcadero Product

Embarcadero Technologies Product Support

Embarcadero Technologies Technical Support

Embarcadero Technologies on the Web

What's New in Change Manager 5.1

Thank you for using Change Manager 5.1. Change Manager provides automation to manual tasks such as database comparisons, difference reporting, and the development of synchronization scripts. Additionally, it provides support for troubleshooting database problems by retaining prior database states and versions in addition to the live source. The application is modularized among CM/Data, CM/Config, and CM/Schema which enables you to control aspects of data, configuration parameter, and schema comparisons, respectively.

Data Masking

Data masking is provided for data comparison jobs and features two masking functions: randomization and shuffling. Randomization inspects each value on a Source and then adds a corresponding new value to the Target. Shuffling randomly assigns different values between the source and the target data sources of the job.

Auto-Synchronization for Data Comparison and Schema Comparison Jobs

New options in data comparison and schema comparison jobs can be selected that will enable automatic synchronization of a target data source when the job is executed.

DBMS Unicode Support

Change Manager now fully supports data sources with Japanese, Korean, and other foreign characters for data, schema object names, and configuration values.

Cross-Platform Support for Schema Comparison Jobs

Cross-platform schema comparisons are now supported between Oracle and SQL Server platforms, and Sybase and SQL Server platforms, for the following objects: Tables, Unique Keys, Check Constraints, Foreign Keys, Indexes, Primary Keys, and Views.

Project Creation and Management

The Explorer view enables you to create projects, in addition to the 'Change Management' default project. Subsequently, Jobs, Standards, and Synchronization Scripts can then be saved to different projects for file organization and performance needs.

Job Notification Enhancements

Job Notification options have been expanded to include File System parameters, for sending notifications to local or network directories, and System Tray parameters, for enabling pop-up notifications on your Desktop.

New History Tab

A History tab has been added to the Data Comparison Job Editor. This feature tracks the execution activities of the specified job, and displays information such as the date of execution, host name, and the synchronization methods that were selected (None, Script, or Automatic Synchronization).

Enhanced Data Comparison Mapping

The Mapping tab of the Data Comparison Job Editor has been enhanced to feature high-level alters and warning when invalid or incomplete mapping is detected. Additionally, new Mapping functionality enables you to set custom warning levels for criteria such as length mismatches, constraints on the target, and precision/scale differences.

Release Notes

System Requirements

Change Manager supports the following operating systems:

DBMS Support

Change Manager supports the following platforms.

Important Advisory Notes

Linux Installation Notes

Known Issues

  • General
  • Schema Comparison
  • Data Comparison

    Upgrading from Version 4.0 or 5.0 to 5.1

    Change Manager 5.1 provides an upgrade process for moving jobs and other information from an existing Change Manager 4.0 and 5.0 installations. All objects can be imported from version 5.0.

    The following objects can be imported from version 4.0:

    The following objects cannot be imported from version 4.0:

    Note: Change Manager 4.0 can remain installed to access archives and reports.

    To import objects from Change Manager 4.0:

    1. To import schema comparison jobs, obtain and install cmschema_40_932_upgrade.exe from Embarcadero Technologies.

    2. Launch Change Manager 5.1 and follow the wizard to "Import data sources, jobs, and settings from a previous version of Change Manager"

    You can rerun the import process at any time by issuing the File > Import command in Change Manager 5.0. Consult the online help for more information regarding the 'Import' command, or refer to the Installation Guide for more information about the upgrade process.

    Bug Fixes


    Bugs fixed in Change Manager 5.1
    Bug DBMS Version Description
    3101 All All Config: Update Configuration Standards to allow for static properties to be used independent of whether there are dynamic sources present.
    2063 All All Data: When using shuffle over multiple columns, data is being kept together and only shuffled down one spot in relation to the PK.
    2063 Oracle All Data: Comparing Oracle 10.2 to SQL Server 2005 - missing one NOT NULL row and a DATE column (in Oracle).
    2063 Oracle All Schema: The sync action for identical Oracle packages (with the same Functions and Procedure properties) is Extended Alter instead of None.
    2748 All All Schema: Indexes created with spaces within quotes on Oracle are seen without spaces inside the Refinements page.
    2467 Oracle All Schema: Identical indexes are seen as different on Oracle.
    3461 Oracle All Schema: There is an Alter instead of Extended Alter when comparison tables with LOB_storage on Oracle.
    3605 Oracle All Schema: If Oracle's XML DB is not installed, then comparing tables will result in an error in the Error Log: "An error occurred while populating table... ORA-00942: table or view does not exist."
    3611 Sybase All Schema: Stack trace errors when comparing partitioned Sybase tables.
    3696 Oracle All Schema: Oracle 10g XE - Connectivity error when executing 2nd comparison job.
    3858 All All Schema: Objects cannot be populated if you uncheck the root node of the Object tree when using an archive as comparison source.
    3958 Oracle All Schema: Comparing two Oracle XE 10 data source gives incorrect datatype results.
    4767 All All Schema: Local property for remote server not stored in archive properly.
    5228 Oracle All Schema: Archive cannot be saved for CONTEXT type INDEX on Oracle.
    2865 All All Schema: Alter resolution with no script when comparing tables on ORACLE.
    3723 All All Schema: DDLRuntimeException: The ObjectRoot is in an inconsistent state (text has not been set).
    4076 All All Schema: CM doesn't really unlicense the licensed data sources.
    4397 All All Schema: Fix this in Thunderbolt-emfdev- Schema Archive/Comparison fails because it doesn't check if DBMS_JAVA java packages are installed when trying to populate Java Sources.
    5109 All All Schema: Schema Archive and Schema Comparison fail for Oracle data sources without XML DB.
    5252 All All Schema: Number precision issue - Table sync creation script is incorrectly handling NUMBER column data type, an (*,0) is issued.
    5257 All All Schema: Data issues when trying to sync up a large migration that include Index organized Tables.
    3169 All All Schema: The tablespaces on DB2 do not match when a comparison is performed for all objects.
    1999 All All Schema: Buffer pools that have the same name are not matched DB2 9.1 source DB2 9.5 target.
    4197 All All Schema: Options to Sync DDL and/or DDL Diff have been added to Schema Reports.
    1174 All All Schema: Request for the ability to view and run the HTML Comparison Sync report like the initial comparison sync report.
    1586 All All Schema: When performing an old archive job, Change Manager should pick up new objects automatically.
    1767 All All Schema: As a user I can create projects for Change Manager.
    1952 All All Schema: The sync action for tables that differ on columns should be alter and is extended alter.
    2123 All All Schema: The sync action for identical index-organized tables on Oracle is Extended-Alter instead of None.
    2467 All All Schema: Identical indexes are seen as different on Oracle.
    3325 All All Schema: INDEXES, FOREIGN KEYS, and TRIGGERS are not recreated with the script for extended alter on Tables.
    3851 All All Schema: UI: Add 'Next' to each job work flow screen to make it easier for users to follow.
    3893 All All Schema: Create resolution instead of None for more types when running a schema comparison job with an archive as the target.
    3931 All All Schema: Constant login error messages on the Refinements options tab - this seems to affect the loading of objects in the Object Refinement section.
    4257 All All Schema: Add feature to test SMTP email notification, similiar to CM 3.0.
    4281 All All Schema: Regression: Error when connecting to database server when the user does not have permissions for all hosted databases.
    4298 All All Schema: Schema comparison fails for indexes on Sybase.
    4344 All All Schema: SCHEMA_COMPARE: Does not show a table difference when the entire DB2 database is compared.
    4345 All All Schema: Flag check constraints as matched and will be recreated when they match, but they need to be rebuilt due to an extended alter on the table to which they belong.
    4354 All All Schema: Schema Archive/Comparison doesn't check if XML DB components are installed when trying to populate XML schemas.
    4355 All All Schema: Schema Archive/Comparison fails because it doesn't check if DBMS_JAVA java packages are installed when trying to populate Java Sources.
    4486 All All Schema: Wrong resolution when comparing tables using archive vs. live data source on MS SQL.
    4767 All All Schema: Local property for remote server not stored in archive properly.
    4937 All All Schema: Wrong Create DDL generated for tables on Sybase.
    4938 All All Schema: Comparison fails for tables that have comments on columns.
    5181 All All Schema: Incorect script ordering for foreign keys: generated script tries to create them before creating the parent table.
    11489 MS SQL Server All Schema: Identical defaults and bound tables are seen as different on Sql Server.

    Additional Resources

    Licensing Your Embarcadero Technologies Product

    All Embarcadero Technologies products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. To license your product, use the License Request Wizard found in the Help menu of your respective product. If you have not yet purchased your Embarcadero Technologies product, contact [email protected], or [email protected] for sales in the EMEA region.

    Embarcadero Technologies Product Support

    The Embarcadero Technologies Web site is an excellent source for additional product information, including white papers, articles, discussion forums, and the Embarcadero Knowledge Base. Visit www.embarcadero.com/support, or click any of the links below, to find:

    Embarcadero Technologies Technical Support

    If you have a valid maintenance contract with Embarcadero Technologies, the Embarcadero Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero Technologies products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation (14 days).

    We encourage you to open technical support cases via the Technical Support request form. For additional information about Embarcadero Technologies Technical Support, visit the Support section of our Web site.

    Embarcadero Technologies on the Web

    To download evaluations of other Embarcadero Technologies products or to learn more about our company and our products visit us at www.embarcadero.com.