• SQL Filter's conditions changed. In 5.0.3, the conditions within a SQL Filter are applied in an AND manner (an intersection of the conditions specified), but in 5.1, the conditions are applied in an OR manner (a reunion of conditions).
• Type filter text from Data Source Explorer does not apply correctly for imported data sources.
• The SQL Editor doesn't have an option to Set ON/OFF ARITHABORT for SQL Server. The DML generated by data comparison will fail on tables with indexes on computed columns or indexed views if the default Server setting is OFF.
• Running jobs from the command line is not yet supported for the All Access InstantOn version of Change Manager.
• The CM Schema 4.0 943 patch needs to be run twice in order to successfully update an older CM Schema installation.
• Code complete is available only after you enable indexing of the specific data source.
• While licensing, if the error "Cannot find base license" appears, try removing the line: "[email protected]/change_manager_5/configuration" from the change.ini file and changec.ini file in the installation folder of Change Manager 5.1.
• Users of InterBase may experience difficulties using the SQL Editor in some isolated cases. You can disable parsing for the SQL Editor script-by-script by right-clicking on the file in the Navigator view and changing the Parser Settings. Contact support for more information.

• The Ignore Object Permissions option for schema comparison jobs does not work if the Enable Dependency Linking option is not selected in the Preferences page. By default, Enable Dependency Linking is unchecked for Oracle, so all Grant statements for Oracle objects are not extracted and compared.
• Identical views with different Header comments cannot be synchronized on SQL Server.
• Comparison fail views on SQL Server if the "Compatibility level" server property is set to 70=SQL Server 7.0.
• Comparison fails for Tables and Indexes on DB2 if the system temporary tablespace is a pagesize smaller than 8k. We recommend using a 16k pagesize so that Change Manger queries run seamlessly.
• When using DB2 version 8.1 with different collation between the source and target, the object matching will not be correct due to an IBM server known limitation.
• Identical views are seen as different when comparing cross platform objects SQL Server vs. Oracle due to text property which specifies the view columns on Oracle. The same problem occurs for SQL Server vs. Sybase, due to the way that Sybase returns the select statement.
• Identical Check constraints are seen as different when comparing objects on Oracle, Sybase towards SQL Server, due to the way SQL Server returns check conditions.
• When comparing tables among different versions of Oracle, the default values for Storage parameters will be removed from synchronization.
• The options "Ignore Constraint Names", "Exists in Target Only (Drop)", and "Ignore Specific Name" work only for object types for which all items are included on the refinements tab. Specific object selection will invalidate these option selections.

• For MS SQL, you should manually exclude System Databases from any Data Movement and Data comparison (e.g. master, msdb, model, etc.) in order to avoid any alteration on data dictionary. See http://msdn.microsoft.com/en-us/library/aa260604.aspx and http://msdn.microsoft.com/en-us/library/ms179932.aspx.
• Data Autosynchronization Limitations:

  a. When updating the IBM DB2 client with new patches, or upgrading from the installed version, the client needs to be rebound to the IBM DB2 server. If rebinding is not performed, there will be problems in getting metadata using the DB2 driver. One solution is to drop and recreate the database if you are unconcerned about the data in that database. This will automatically perform the required bindings.

  b. For tables having columns with data type DECFLOAT, data migration gives null pointer exception and the data does not get moved properly.

  c. For tables having columns with data type MLSLabel Oracle driver gives a null pointer exception.

  d. Data Autosynchronization is not supported for versions of InterBase 2007 below Service Pack 3 (v8.1.1.333)

• Use the trim trailing spaces option when doing a cross-platform comparison for tables with binary, nchar, numeric or unichar data types towards SQL Server, because the server is appending trailing blanks and 0s when data is inserted in the tables.

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:

• Data Sources
• All Comparison Jobs (Data, Configuration, and Schema)
• Configuration Archives
• Configuration Standards

The following objects cannot be imported from version 4.0:

• Schema Archives
• Synchronization Scripts
• Reports
• Command Line Automation (scheduled jobs, batch files, etc.)

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 clicking File > Import 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

Additional Resources

Licensing Your Embarcadero Technologies Product

All Embarcadero Technologies products include a 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 http://www.embarcadero.com/support/index.php, or click any of the links below, to find:

• Documentation
• Online Demos
• Technical Papers
• Discussion Forums

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.

We encourage you to open technical support cases using 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 http://www.embarcadero.com/.