Embarcadero® Change Manager™ Read Me

Welcome to Embarcadero® Change Manager™ 5.1.2

Change Manager Web Site | Embarcadero Technologies Home | Technical Support

ReadMe Last Published: November 10, 2009. Any updates to these notes will be available at http://docs.embarcadero.com.

Thank you for using Embarcadero Change Manager! Change Manager’s 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 5.1.2

SQL Server DATETIME Enhancement

What Was New in Change Manager 5.1.1

InterBase and Firebird Support

What Was New in Change Manager 5.1

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.2

SQL Server DATETIME Enhancement

You can now use SQL Server DATETIME in a comparison key in data comparison jobs.

What Was New in Change Manager 5.1.1

InterBase and Firebird Support

Change Manager now includes support for InterBase 2007 and 2009 as well as Firebird 1.5 and 2.0.

What Was New in Change Manager 5.1

Data Masking

Change Manager 5.1 provides data masking 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 automatically synchronization a target data source when the job runs.

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 lets you create new projects, in addition to the 'Change Management' default project. Subsequently, you can save jobs, standards, and synchronization scripts to different projects to improve file organization and increase productivity.

Job Notification Enhancements

The Job Notification view has two new options. It can write a notification log to a local or network directory using file system parameters, and it can send pop-up notifications to your desktop using the system tray parameters.

New History Tab

The Data Comparison Job Editor has a new History tab. This feature tracks the activities of the job, and displays information such as the date it was run, the host name, and the synchronization methods that were selected (None, Script, or Automatic Synchronization).

Enhanced Data Comparison Mapping

The Data Comparison Job Editor Mapping tab now produces warnings when it detects invalid or incomplete mapping. You can 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:

Microsoft Windows XP (x86-32, Win32), Vista (x86-32, Win32), or Microsoft Windows Server 2003)
Red Hat Enterprise Linux 5.0, x86-32, GTK 2 or SuSe Linux Enterprise Server (x86) GTK+ 2.x
1.2 GHz Processor
1 GB of RAM
500 MB of hard disk space
1024 x 768 display

DBMS Support

Change Manager supports the following platforms.

Oracle 8i - 11g
Sybase 12.5 - 15.0, 15.0.1, 15.0.2
IBM DB2 LUW 8.0 - 9.5
Microsoft SQL Server 2000, 2005, and 2008
InterBase 2007, 2009
Firebird 1.5, 2.0

Important Advisory Notes

You can install Change Manager as an Eclipse plugin. This installation feature lets Eclipse users add a version of Change Manager with full functionality to their development environment without requiring the standalone application.
Change Manager 5.1.1 is compatible as a plugin with Eclipse 3.5 based RCPs including Rapid SQL Developer 2.1 and DB Optimizer 2.0. It is not compatible as a plugin with Rapid SQL Developer 2.0 and DB Optimizer 1.5.

Known Issues

General

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.

Schema Comparison

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 page size smaller than 8k. We recommend using a 16k page size 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.

Data Comparison

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 Auto-synchronization Limitations:
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

Bugs fixed in Change Manager 5.1.2

Bug	DBMS	Description
4459	Oracle	Not null constraints are incorrectly displayed within Individual results page
4486	SQL Server	Incorrect resolution when comparing tables using archive versus live data source
4494	Oracle	When comparing oracle 9i tables, FLOAT(126) is seen as FLOAT(63)
4599	Sybase	Passwords currently are not encrypted when they are sent during login from CM 4.0 to Sybase
4785	SQL Server	Alter user with domain login does not enclose properly
4921	SQL Server	Need Match/Recreate to be required on dependent objects for ALTER on tables
5066	SQL Server	Request for the support of the SQL Server 2008 FILESTREAM feature
5092	All	Inconsistently generated sync script when using the Show/Hide Objects filters
5245	All	Update progress status in schema comparisons and archive jobs to include the owner and name of the current object being processed
5295	DB/2	Columns are not populated for indexes, triggering mismatches
5363	Oracle	Schema comparison fails for tables on Oracle 8.1.5
5378	All	When importing a job, you are asked for credentials even though they are already set
11668	Sybase, DB2	A spurious null character at the end of a procedure causes errors when saving schema archive jobs
11731	Sybase	Identical users with a different permission order are seen as different on Sybase
11821	SQL Server	ALTER LOGIN for Passwords sync script is incorrectly generated
11878	All	Request that the application not connect if the job is only running
11892	DB/2	Regression: schema comparison fails for indexes on DB2
11893	DB/2	Regression: schema comparison fails for tables on DB2
11949	DB/2	Wrong Create DDL generated for Views on DB2
11961	Interbase	Moving data from one table to another, with the same user on a InterBase server, does not work
12007	Firebird	Not able to connect to a Firebird data source that is set to use a port different than 3050
12016	Oracle	Schema Archive capture fails with a Java null pointer exception error
12018	Oracle	Schema archive fails for Redo Log Groups on Oracle
12038	All	Second job does not ask for credentials again, even though it should when Auto-Connect is unchecked
12048	DB2	Error occurred during population of refinements mode
12049	DB2	Does not create the alters to add the columns to the target table
12054	Sybase, SQL Server	Auto discover does not work for SQL Server/Sybase data sources
12056	Oracle, DB2, Sybase	Wrong DDL generated for foreign keys when cross-schema referential integrity is involved
12097	SQL Server	Data comparison errors when data masking is being used
12113	Oracle	Check constraint objects are incorrectly ordered when doing archive to archive comparisons
12127	SQL Server	Add RECONFIGURE statement to configuration sync script in order to persist the changed configuration value.
12141	All	Attaching a sync script to a file system notifier does not work for schema comparison jobs
12156	All	NullPointerException when a schema archive job finishes
12161	All	Instead of selected items ONLY being generated, ALL items are generated in a sync script
12168	SQL Server	The Drop statements are incorrectly ordered when a foreign key references an unique index
12266	All	The timezone-specific date datatypes are erroneously displayed in the Database Results page
12288	Oracle	Schema archive for Oracle CK, PK and TABLES system objects are not filtered
12290	SQL Server	Data compression comparison fails when the TIME data type is the comparison key
12292	Oracle	Schema comparison fails for tables with comments on Oracle
12294	Oracle	Incorrect matching for Oracle indexes with parents on different schemas
12296	All	Archive versions are not displaying the correct Create Date

Bugs fixed in Change Manager 5.1.1

Bug	DBMS	Version	Description
3333	All	All	Running a schema comparison opens a very large number of connections
4440	Oracle	All	Schema Archive fails for tables on Oracle and the version cannot be saved
4619	All	All	Ignore name case option generates create with columns in random order
5367	All	All	Permissions are not generated for extended alters on tables
5422	Oracle	All	Permissions on an Oracle Stored Procedure are ignored even when Ignore Object Permissions is unchecked
11330	All	All	If you install on Windows 7 or Vista and you are logged in with a limited user account no install files are copied
11501	All	All	Dependencies are created before tables within create sync scripts when a schema archive is the source of the comparison
11583	All	All	Cannot import from CM/Schema 4.0 unless you have a valid CM/Config CM/Data 4.0 workspace
11722	Microsoft SQL Server	All	Ignore constraint names does not ignore DEFAULT constraints on SQL Server
11849	Oracle	All	Change Manager is included differences in unique key statistics on Oracle 10g comparisons

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 does not un-license the licensed data sources.
4397	All	All	Schema: Schema archive/comparison fails because it does not check whether 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, similar 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.

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:

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/.