Welcome to Embarcadero® DB Change Manager XE and 5.5.2

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

Clone job support

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

Add execution estimation for jobs on schema (archive, autosync, comparison) and data (comparison, masking)

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

System Requirements

Important Advisory Notes

Known Issues

Upgrading to 5.5

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

 

Updates to generated scripts    

 

  There are updates to several items including the USE statement, view/table references, and “Set quoted identifiers”.

 

Miscellaneous schema updates

 

  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

DBMS Support

Change Manager supports the following platforms.

Important Advisory Notes

·       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)


Upgrading to 5.5


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.