Change Manager Web Site | Embarcadero Technologies Home | Technical Support
ReadMe Last Published: July 8, 2010. 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 DB Change Manager 5.5.2
There have been miscellaneous quality improvements and some new small features including: status compare for Oracle procedure, function, package and trigger in a schema comparison job, the ability to save generated SQL script to a user specified location, and HTTP server support for reports.
What's New in DB Change Manager 5.5.1
An error that caused the ToolBox to not recognize that DB Change Manager was installed is now resolved.
An issue that required setting DB Change Manager to XP compatibility level on Windows 7 is now resolved.
What's New in DB Change Manager 5.5
The product name “Change Manager” is now “DB Change Manager”.
There is now an XE version for use with Embarcadero ToolCloud.
DB Change Manager now runs on Microsoft Windows 7 (x86-32, Win32).
The Installation Guide, New Features Guide, and Evaluation Guide have been combined into a new Quick Start Guide.
New features include:
Explore/compare restore versions of archived objects
Custom ignore options, with import/export enhancements
Include automatically dependent objects
Add support to
schedule a job in schema comparison
General UI and usability improvements include:
New toolbars and toolbars configuration
Updated File, Preferences, and View menus
Support for multiple Eclipse workspaces with separate data and conversion support
Cross platform schema comparison between Interbase and Firebird
Optimize reporting runtime and memory
Some optimization on data movement
Add date info to archive comparison report
Miscellaneous updates include:
Fix some concurrency issues on running population
Populate users in mapping page on Oracle
Script updates (USE statement, view/table references, Set quoted identifiers )
Schema misc: exclude dump files from schema, schema comparison summary view updates
Release Notes
Additional Resources
Licensing Your Embarcadero Product
Embarcadero Technologies Product Support
Embarcadero Technologies Technical Support
Embarcadero Technologies on the Web
WHAT'S NEW IN DB CHANGE MANAGER 5.5
See the DB Change Manager User Guide or the online help for details about the new features.
Explore, compare, and restore versions of archived objects
For archive job results, a new dialog shows the history of an object. You can compare two historical versions, and you can restore a prior version from a list of historical versions.
Custom ignore options, with import/export enhancements
You can select object types and properties to ignore during a comparison. The Options tab has “Custom options” with options that apply to the platform and types you selected in the Refinements tab. (This feature does not apply to cross-platform comparisons.)
Include automatically dependent objects
Dependent objects for a table will be automatically included when running a schema comparison job.
Clone a schema comparison job
You can now clone a schema comparison job, with the option to select multiple data sources. The job will be cloned for every selected target. There is also an option to preserve target mapping from the cloned job.
Add support to schedule a job in schema comparison
You can schedule a job and can get a command line script for the scheduler. The schedule properties are similar to Change Manager 4.0.
New toolbars and toolbars configuration
There are new toolbars for layout and preferences, data sources, and SQL development. You can control the toolbar settings.
Updated File, Preferences, and View menus
The File menu is updated for easier operations. There is a new Preferences menu for easier access to commonly used preferences. There is a new View menu for better organization and easy navigation.
Support multiple eclipse workspaces with separate data and conversion support
You can switch workspaces with your own set of projects, files, and data sources. Older workspaces can be converted and backed up. During conversion data sources, preferences and options are preserved.
More information about the progress of jobs as they run
Schema archive, comparison, and synchronization jobs, and data comparison and masking jobs now display a continuously updated assessment of the duration of a the job.
Cross platform schema comparison between InterBase and Firebird
You can now run InterBase to Firebird and Firebird to InterBase schema comparison and synchronization jobs.
Optimized reporting runtime and memory
The runtime and memory used for generating large reports has been reduced.
Add date and time information to archive comparison reports
Reports include now the data and time of the archive version.
Populate users in mapping page on Oracle
All users as oppose to only schema owners are displayed.
There are updates to several items including the USE statement, view/table references, and “Set quoted identifiers”.
There are updates to items including “exclude dump files from schema”, and to the schema comparison summary view.
RELEASE NOTES
System Requirements
Change Manager supports the following operating systems:
· Microsoft Windows 7 (x86-32, Win32), ), Microsoft Windows 2008 (x86-32, Win32), 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
Change Manager supports the following platforms.
· If you previously had DB Change Manager 5.5 installed on Windows 7 please Uninstall it before installing the 5.5.1 build trough Control Panel > Programs & Features or by executing the uninstaller within C:\Program Files (x86)\Embarcadero\DB Change Manager 5.5\Uninstall_Embarcadero DB Change Manager 5.5\
Known Issues
· General
· Schema Comparison
· Data Comparison
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 Auto-synchronization is not supported for versions of InterBase 2007 below Service Pack 3 (v8.1.1.333)
DB Change Manager 5.5 provides an upgrade process for moving jobs and other information from an existing Change Manager 4.0, 5.0, and 5.1.x installations.
Upgrading from Version 5.0 or 5.1.x to Version 5.5.x
All objects can be imported from version 5.0 and 5.1.x to version 5.5.x.
To upgrade:
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 5.5.x.
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:
• Select File > Import.
• Select Change Manager Workspace from the Embarcadero group and click Next.
5. Select the version of Change Manager from which to import.
6. If you are importing from 5.0.x or 5.1.x, 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 version 5.5.x.
Upgrading from Version 4.0 to 5.5.x
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:
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 or 5.1.x".
Bug Fixes
Bugs fixed in Change Manager 5.5.2
Bug |
DBMS |
Description |
2561 |
SQL Server |
Server Extended properties not included in the sync file for tables. |
11853 |
All |
Data source Properties fields are not editable, a Connect and Disconnect has to be done in order for the fields to be enabled once more |
11877 |
All |
Adding new datasource in a new schema comparison task causes the task to fail to save |
12309 |
SQL Server |
Data comparison errors, errors reads Internal Error has occurred |
12480 |
SQL Server |
Random issue with missing views in comparison task with archives |
12678 |
DB2 |
Wrong sync script when you schema compare 2 partitioned table spaces (DB2) |
12852 |
Oracle |
Invalid script generated for synchronizing materialized views on Oracle |
13036 |
Oracle |
SCHEMA_COMPARE: Generated Sync script is not in correct order for Oracle for ALTER TABLE DROP PK and ALTER TABLE DROP RELATED INDEX statements |
13044 |
SQL Server |
Same table with extended properties on SQL Server is seen as different |
13049 |
All |
Schema Comparison is not retrieving PK "USING INDEX" from database - Although archive job does causing compare errors. |
13050 |
All |
Computed columns are not extracted correctly on SQL Server - spaces are trimmed |
13081 |
All |
In Schema Comparison of archives, the MAPPING tab is not getting update when Schema Overview Source and Target have "Most Recent version" selected |
13101 |
SQL Server |
Invalid Create script for views which use select statement aliases |
13105 |
SQL Server |
Incompatible status triggered when comparing views with functions on SQL Server |
13118 |
All |
Identical Materialized Views seen as different. |
13141 |
Sybase |
Command line jobs fail for Sybase 15 |
|
|
|
Bugs fixed in Change Manager 5.5
Bug |
DBMS |
Description |
12649 |
Sybase |
SET QUOTED_IDENTIFIER is not set in front of views on Sybase when generating sync script for comparison on archive. |
12654 |
SQL Server |
The new created PK for a parit of tables is not picked up when reinspect the parent database pair for a data comparison job |
12679 |
DB/2 |
Wrong sync script when you schema compare a partitioned table space and a default table space (DB2) |
12842 |
SQL Server |
Identical procedures seen as different on sql server |
12868 |
SQL Server |
Schema comparison fails on tables with extended proprieties on SQL Server |
11878 |
All |
Request for the application to not connect if the job is just running |
12160 |
Oracle |
An error occurred while populating Table |
12500 |
Oracle |
NPE thrown when comparing oracle tables |
12836 |
Oracle |
Aditional invalid Alter statement generated when comparing oracle tables with storage differences |
12834 |
Oracle |
Schema comparison fails when comparing materialized views that fetch data from a table on a different server linked trough a database link |
12831 |
DB/2 |
Wrong sync script when comparing 2 identical tables that have a column with a DATE DEFAUL NULL value (DB2) |
12723 |
Oracle |
When the script is run, without modification customer receives error - ORA-02145: missing STORAGE option |
12697 |
All |
The 'Select Data Source ' link is missing if you choose to open a compare job by right click on a data source (PERSONAL and STANDARD) |
12614 |
All |
The Source server connection is checked if you do a comparison between an archive version and a live data source |
12590 |
All |
When using a schema archive into a comparison and select the second or most recent version it is stamp with the compare creation date. |
12546 |
All |
SCHEMA_COMPARE: Error counter on results page not correct when compare job returns errors. |
12409 |
Sybase |
Schema archive fails for Databases on SYBASE for a Refinements specific selection |
12360 |
Oracle |
On Schema Comparison task, the Primary and Foreign keys are completely unrecognized on the Target and so the sync actions are all CREATE statements |
12335 |
SQL Server |
The data comparison fails for views if you set a CHARACTER data type as comparison key |
12317 |
SQL Server |
The CM closes if you do mapping for 2 SQL Servers with trusted connections |
12310 |
SQL Server |
SQLException occurs while trying to compare table/view |
12251 |
Oracle |
Alter with no script when comparing tables different on column size on Oracle |
12250 |
Interbase |
SCHEMA_COMPARE: Generated Sync script is not in correct order for Interbase - ALTER TRIGGER appears before ALTER TABLE. |
12225 |
Oracle |
Archive Comparison results show the GRANTS are doubled in the sync script |
12152 |
All |
Archive job file PATH is showing confusing backslashes (forward slash is shown even though file is on a Windows OS) |
12083 |
SQL Server |
An error occurred while populating Procedure |
11686 |
Oracle |
Errors occur in results of schema comparison, An error occurred while populating (OBJECT) and Failed to create a connection. Url or driver class may be incorrect. |
11671 |
All |
Request for Archive Comparison reports to include archive version date time creation |
11560 |
All |
Email configuration user interface improvements |
11423 |
Oracle |
Update/Delete statements are improperly generated by data resolution when raw data type is comparison key |
11414 |
All |
The Change Data Source links are missing from the schema comparison overview Page for CM Personal and Standard |
11335 |
SQL Server |
Schema comparison generates the Create statement for renamed procedures, triggers and views with the old name - SQL Server |
10717 |
DB/2 |
AtomContainerSchemaPopulator error message appears when making the inspect for data comparison |
7198 |
All |
Red X icon for Compliance feature looks like job has failed instead of Compliance not met. |
7132 |
All |
Wrong messages for a valid command line job |
5412 |
All |
As a user I don't have to scroll to see the "Individual Results" link in the schema comparison summary view |
5209 |
All |
When comparing a number of tables in two databases the commands appear to be out of order |
4477 |
Oracle |
Within Mapping page all the users should be populated for an Oracle target data source |
4320 |
SQL Server |
The customer would like the USE statement to be pointing to the correct database when you use "Open Script in SQL Editor" |
3896 |
All |
UI: Ability to specify 'Working' directory - like CM\Schema 40 |
3839 |
SQL Server |
Views and Database "populate" errors in comparison task results - ObjectRuntimeException: populateCollectionAttributes() failed to populate for object type View |
3450 |
All |
As a user I can ignore sequence number seed changes when comparing and monitoring data sources |
3158 |
All |
As a user I can check an option to ignore defaults in comparison |
2680 |
Oracle |
We should exclude dump tables like BINxxx from schema jobs - ORACLE |
823 |
Sybase, SQL Server |
As a user I can ignore log file and database file size differences when comparing databases |
Bugs fixed in Change Manager 5.1.3
Bug |
DBMS |
Description |
11953 |
All |
In All-Access ToolCloud, database platform licenses were incorrectly checked out when the Eclipse application launched. |
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 |
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. |