Welcome to Embarcadero® DB Change Manager™ 2016 (6.3.3)

Change Manager Home | Change Manager Documentation | Embarcadero Technical Support | www.embarcadero.com

ReadMe Last Published: February 1, 2016. Any updates to these notes will be available at http://docs.embarcadero.com.


Thank you for using Embarcadero DB Change Manager! Its compare, synchronization, data masking, and auditing capabilities let you track and report on changes, roll out new releases, and pinpoint performance problems resulting from changes to the data, schema, and database configurations. By comparing a live database to a schema or configuration “snapshot” administrators can quickly identify changes and correct problems. By monitoring configuration settings, DBAs can ensure compliance with regulatory policies and performance standards, and maintain overall database performance and availability.

What's New in Change Manager

DBMS Version Support

OS Support

Java and Eclipse

Requirements

System Requirements

DBMS Support

Release Notes

Important Advisory Notes

Upgrade 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 2016

DBMS Version Support

Change Manager now supports the following DBMS versions:

OS Support

Change Manager is now fully tested to run on the Windows 8 platform.

Java and Eclipse

Change Manager now uses Java 7 and the Eclipse 3.8.2 platform.

Requirements

System Requirements

Change Manager requires the following:

The following operating systems are not supported in the 2016 release:

DBMS Support

Change Manager supports the following platforms.

Release Notes

Important Advisory Notes

Upgrade Notes

DB Change Manager 2016 should be installed in a different directory than 4.x or 5.x versions. If DB Change Manager is installed in the same directory, the following error will result at application start up: "Unable to read workbench state. Workbench UI layout will be reset."

If a 4.x or 5.x version is already installed on your machine, either change the default Workspace or delete all files from the Workspace directory. The Workspace directory location appears whenever you start DB Change Manager and can be redefined from this dialog box. If the same Workspace is indicated for the new version, as was indicated previously, the following error will result: "Cannot restore workbench layout."

If DB Change Manager is already running, you can also modify the Workspace directory by choosing File > Switch Workspace > Other from the Main menu.

The format in which schema comparisons are saved has changed in 6.x. Use the import feature to import pre-6.0 schema comparison jobs.

DB Change Manager 2016 provides an upgrade process for moving jobs and other information from an existing Change Manager 4.0, 5.0, 5.1.x, 5.5.x or 5.6 installations. No upgrade process is required to move from 6.x installations to Change Manager 2016 (6.3).

NOTE: You do not have to upgrade to 5.6 and then to Change Manager 2016 (6.3). The import procedure is the same.

Upgrading from Version 5.0, 5.1.x, 5.5.x or 5.6 to Change Manager 2016 (6.3)

All objects can be imported from version 5.0, 5.1.x, 5.5.x or 5.6 to Change Manager 2016 (6.3).

To upgrade from 5.0, 5.1.x, 5.5.x or 5.6:

  1. Make sure that the earlier product is not running and that no command line jobs are being processed.
  2. Install and run DB Change Manager 2016 in a different directory than the previous installation.
  3. The Welcome to DB Change Manager dialog opens with the Setup and Import data sources, jobs, and settings from a previous version import options selected.
  4. Click Get Started to launch the Import Wizard. Alternatively, you can launch the Import Wizard from the main menu:
  5. Select the version of Change Manager from which to import.
  6. Select the location of your DB Change Manager workspace. The default value is the default workspace, so you need only change this value if you configured DB Change Manager to store the workspace in a custom location.
  7. The wizard imports the items from the previous Change Manager version. Click Next to continue through each step of the wizard.
  8. Click Finish. The jobs are imported to Change Manager 2016.

Upgrading from Version CMSchema 4.0 or CMData/Config 4.0 to Change Manager 2016

The following objects can be imported from version 4.0:

The following objects cannot be imported from version 4.0:

Note: 4.0 should remain installed to access any archives and reports.

To upgrade from CM Schema 4.0:

  1. To import schema comparison jobs from 4.0, obtain and install cmschema_40_932_upgrade.exe from your Embarcadero Technologies Support representative.
  2. Run cmschema_40_932_upgrade.exe to convert the schema component jobs from version 4.0 to 5.0, which uses an XML-based format.
  3. Follow the steps as described in the previous section, "Upgrading from Version 5.0, 5.1.x, 5.5.x or 5.6".

Known Issues

General

Schema Comparison

Data Comparison

Bug Fixes

Customer-reported bugs fixed for the Change Manager 2016 (6.3.3) release:
Bug DBMS Description
SC-14595 Sybase ASE Schema Compare - Triggers and Logical Foreign Keys failures.
SC-14594 SQL Server Column Width Archive Issue.
SC-14591 SQL Server Identity Columns are not correctly Extracted when Archiving a Database.
SC-14584 Sybase ASE Schema archive job creates incorrect SQL for a view with column level permissions.
SC-14580 Oracle Schema Comparison - SYS.INSERT_TSN_LIST$ is not found in some cases.
SC-14567 Oracle Case # 00425065: Schema Compare - Missing Comparison Configurations.
SC-14565 Oracle Owners are not populated in refinements tab.
SC-14553 Oracle Case # 00413533 - Table difference being reported when there are no differences.
SC-14547 All Ability to include > 10000 objects in a Schema Report.
SC-14524 Sybase ASE Schema archive job creates incorrect SQL for a view with column level permissions.

 

Customer-reported bugs fixed for the Change Manager 2016 (6.3.1) release:
Bug DBMS Description
SC-14489 ALL Linux - Error when generating configuration archive report
SC-14490 SQL Server Incorrect order of statements in the Synch Script
SC-14491 SQL Server Support to ignore object comments for SQL Server on schema comparison
SC-14495 SQL Server Data-synch job start but makes no progress after 4+ hours
SC-14498 MySQL Automatic sync - The progress between sync summary and sync results is not the same

 

Customer-reported bugs fixed for the Change Manager 2016 (6.3) release:
Bug DBMS Description
SC-14281 Sybase [Schema Comparison Job] Procedures showing "Don't Match" but when click View Differences, there are no differences.
SC-14289 SQL Server [Schema Comparison Job] when there is an ALTER procedure after the creation. ANSI_NULLS and QUOTED_IDENTIFIER have been turned off
SC-14463 SQL Server [MSSQLServer] Length of User Defined Datatype in Database Objects is twice [nchar nvarchar]
SC-14470 SQL Server Incorrect comparison of User Defined Types

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. For information on licensing your product, refer to the DBArtisan Installation Guide. 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.