Embarcadero Change Manager ReadMe

Welcome to Change Manager 5.0.1

Change Manager Web Site | Embarcadero Technologies Home | Technical Support

Thank you for using Change Manager 5.0. Change Manager provides automation to manual tasks such as database comparisons, difference reporting, and the development of synchronization scripts. Additionally, it provides support for troubleshooting database problems by retaining prior database states and versions in addition to the live source. The application is modularized among data, configuration, and schema comparison which enables you to control aspects of data, configuration parameter, and schema comparisons, respectively.

What's New in Change Manager 5.0

CM/Schema Integration and Enhancements

Job Explorer

Source Code Control (Project Explorer and Navigator Views)

Data Source Explorer Enhancements

Configuration Standard Enhancements

Data Comparison Job Enhancements

Version Information on CM/Config Jobs

Synchronization Script Enhancements

Job Reporting

Command Line Enhancements

Custom Plug-In Functionality

Release Notes

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

Thank you for using Change Manager 5.0. Change Manager provides automation to manual tasks such as database comparisons, difference reporting, and the development of synchronization scripts. Additionally, it provides support for troubleshooting database problems by retaining prior database states and versions in addition to the live source. The application is modularized among CM/Data, CM/Config, and CM/Schema which enables you to control aspects of data, configuration parameter, and schema comparisons, respectively.

CM/Schema Integration and Enhancements

Change Manager 5.0 features the complete integration of the CM/Schema module into the framework with CM/Data and CM/Config. This major interface rework provides an enhanced user experience by providing improvements in versatility, performance, and comprehension.

Major enhancements include:

Drag and drop functionality when setting up schema comparisons and archives.
Quick type features to find and open jobs.
Quick type features to find data sources.
Single step schema refinement.
Larger editor spaces.
Simultaneous job execution.
One-to-Many option for comparison jobs.
Job History storage for archive and comparison jobs.
Mapping options for pairing database, schemas, and owners for comparison jobs.

Job Explorer

The Job Explorer view replaces Change Explorer, and provides an organized list of Data, Configuration, and Schema jobs from which to explore and manage. It includes enhanced interface and organizational functionality to improve comprehension and the ease at which jobs are set up, managed, and viewed.

Source Code Control (Project Explorer and Navigator Views)

Change Manager 5.0 now supports source code control through compatible source control plug-ins. All data source definitions, jobs, standards, synchronization scripts and archives can be stored as specified file formats, placed in a repository, and shared across multiple instances of the application. To enable this feature, the Project Explorer view organizes XML files that define jobs and stores them in a directory on the system, while the Navigator can be used in conjunction with the implemented source control system to share files across a development team or project.

Data Source Explorer Enhancements

The Auto Discover button scans your system for data sources and automatically adds them to Data Source Explorer. Additionally, the Import command enables you to import data sources from the Windows registry, Eclipse Data Tools Platform (DTP), TOAD, and other instances of Change Manager. Conversely, the Export command enables you to store the current defintions catalog in a file for import purposes on other systems.

Configuration Standard Enhancements

The Standards Explorer view has been removed in Change Manager 5.0, and all configuration standards are now managed via Project Explorer. Additionally, static property definitions are no longer associated with a source. They are simply marked as static and stored as independent values.

Data Comparison Job Enhancements

Data comparison jobs have been enhanced to provide users with a greater control over the comparison and synchronization process.

Data comparison job enhancements include:

Users can specify high-level refinement mapping by selecting a database, schema, or owner prior to entering the lower level refinement process. The Mapping tab automatically updates based on the high-level refinement option.
Two new options are available: 'Check Rows from Source' and 'Check Rows from Target'. 'Check Rows from Source' indicates that the process only examines rows that exist in source tables, while 'Check Rows from Target' indicates that the process only examines rows that exist in target tables. These options can be used when comparing reference data or versioned tables.
The table comparison results display has been enhanced to include paging options that speed up loading and browsing times, as well as a 'Show Rows' command, which filters out specified rows for higher comprehension and ease-of-use when viewing comparison results on large data sources.

Version Information on CM/Config Jobs

Configuration archives, jobs, and standards now include detailed version information regarding each platform.

Synchronization Script Enhancements

When executing synchronization scripts, users can now configure SQL session options, start a transaction, commit a transaction, and rollback transactions, in addition to running the script as normal. Additionally, new formatting capabilities have been provided for the modification of generated scripts. The CTRL+SHIFT+F command formats a synchronization script based on a specified template stored in Change Manager preferences.

Job Reporting Features

New file formats are provided for the generation of job reports. XML, PDF, RTF, CSV, and HTML report files can be generated and saved for all data, configuration, and schema comparison jobs. Additionally, a 'Preview Report' command enables you to open a view of the report prior to saving it for the purposes of previewing the information.

Command Line Enhancements

Change Manager's command line functionality has been enhanced. The Script Generation Wizard now fully supports the production of Linux shell scripts in addition to ANT tasks. Additionally, jobs are now referenced in the system by file name instead of job name or number, and report generation can be included via the -output flag.

Custom Plug-In Functionality

Change Manager now supports the development and implementation of custom plug-ins for job notification and customization. Tutorials are provided with the help for development of job notification enhancement and CM/Config customizations.

Release Notes

Important Advisory Notes

A new installation option enables Change Manager to be installed as an Eclipse plug-in, in addition to the standard installation procedure. This feature enables Eclipse users to add a version of Change Manager with full functionality to their development environment without requiring the standalone application. Enabling Change Manager as a plug-in is not an automated process - refer to the installation manual for more information about this process.

Change Manager now supports a command that enables you to download and install a zip archive file that updates the application from 5.0 to 5.0.1. If you have Change Manager 5.0 installed, access the Help > Software Updates Menu command to update the application.

Known Issues

General

Users may experience memory issues when generating reports that contain 50000 or more differences. A workaround involves increasing the memory available for Change Manager in the change.ini file.
DB2 v8 data sources configured with JDBC Type All drivers are not supported for configuration archives, comparisons, and standards.
The Licensing Update function (via the Help > Embarcadero Licensing > License Updates command in the main menu) is not supported in Change Manager 5.0.1.
When generating a serial key for a Change Manager trial license on Microsoft Vista operating systems, Vista blocks connection to the Embarcadero licensing server, which results in the following message: "Could not connect to server...". To avoid this error, choose the 'Trouble Connecting, Try Web Registration' option instead.

Schema Comparison

Jobs may fail if the SQL Server compatibility level is set to a previous version of SQL Server.
When refining schema comparison jobs on Oracle platforms, the refinements no longer include all users. Only users that own objects in the specified schema are included. Due to this behavior, jobs created in version 5.0 will load without previously selected users, when viewed in version 5.0.1.

Data Comparison

Data comparison results may not always draw correctly.
The data compression option is not recommended between databases on 6All-bit and 32-bit servers.
Comparison keys including columns that total more bytes than can be sorted on the database server will fail the comparison job.

Configuration Comparison

Comparison options (Greater Than, Less Than) may not be available for all parameters.

Bug Fixes

Bugs fixed in Change Manager 5.0.1

Bugs fixed in Change Manager 5.0.
Bug	DBMS	Version	Description
2875	All	All	Schema: Change Manager doesn't make distinctions between indexes with the same name but created for different tables.
2132	All	All	Schema: Change Manager generates dropped NOVALIDATE constraint scripts in compare feature.
3162	All	All	Schema: Difference about PK fillfactor is still reported along with other difference when 'Ignore Storage Comparison' option is enabled.
2691	SQL Server	2005	Schema: SQL Server 2005 index with INCLUDE columns specified does not archive the include option.
2866	All	All	Schema: NPE appears when trying to perform the Save As command on a script.

Bug	DBMS	Version	Description
20	All	All	Schema: Getting "Column to be modified to NULL cannot be modified to NULL" message when altering table column from NOT NULL to NULL in sync script.
53	All	All	Schema: The SYNCH functionality cannot parse foreign characters.
63	All	All	Schema: Options to NOT rename original object if the action fails.
113	All	All	Schema: Unable to receive html notifications when doing a database capture.
281	All	All	Schema: Index difference is not picked up when comparing table with PK to table with PK using Index.
313	All	All	Schema: Job file created by Change Manager contains unmasked username & password.
315	All	All	Schema: Enhancement: Would like to be able to concatenate change notifcation e-mails.
316	All	All	Schema: Compare jobs create the full directory structures for the SQL file whether differences are found or not.
323	SQL Server	All	"Schema 5.0: COMPARE: Requirement for ""Ignore GRANT SELECT statements"" option."
380	SQL Server	All	Schema 5.0: NVARCHAR(MAX) datatypes to a database that has VARCHAR(All000) datatype the resulting SYNC DDL script has NVARCHAR as the datatype with out (MAX) specified.
601	Oracle	All	Schema: Would like much more granularity when comparing constraint names.
605	Oracle	All	Schema: Support for USING NO INDEX clause on materialized views.
608	Oracle	All	Schema: PCTFREE is lost when capturing the index storage clause of a materialized view.
613	All	All	Schema: Application crashes on selecting the 'Options' from the File menu options.
712	Oracle	All	Schema 5.0: FK is created then disabled within Sync Script when FK exists in both compared schemas.
738	SQL Server	All	Schema: BUG Change Manager is not generating or comparing the MS SQL Server Table or Column comments.
766	All	All	Schema 5.0: When capturing an Archive theere is a bug in the way the Stored Procedures are being captured.
773	Oracle	All	Schema: ENHANCEMENT DB Links are getting reported as extended alters.
773	Oracle	All	Schema: BUG SQL output of changes sometimes lists the source tablespace in the tablespace clause even when user specifies otherwise.
785	SQL Server	All	"Schema: Synchronization tables and stored procedures, drop mechanisms are not the same."
860	SQL Server	All	Schema: Sync screen fails with 'the page cannot be displayed' when comparing an index with '_' as a leading char.
933	All	All	Schema 5.0: Warning message appearing when launching application due to old visual source safe server being recognized.
936	Oracle	All	"Schema: Datasources are not discovered or registered automatically when TNS_ADMIN registry key is used to point to the remote location of TNSNames.ORA file , while they are discovered in Net8Assistant."
937	SQL Server	All	Schema: Ignore Constaint Name Difference is not working.
952	All	All	Schema: Notification email entered in the Options section for notifications does not get populated in the dialogue box.
966	Oracle	All	Schema: Error code 955 SQL state All2000: ORA-00955:.
983	SQL Server	All	Schema: Generated Sync Scripts are not correct - deleted table object reappears in the view synchronization scripts.
983	SQL Server	All	"Schema: ' NOT ' SYNTAX ERRROR IN EXTENDED ALTER - syntax ""Collate"" causing error in sync script."
985	All	All	"Schema: Synchronization scripts for tables generate a COLLATE on some data types (uniqueidentifier, datetime, int) with out a collation named."
996	SQL Server	All	Schema: Failure to create brackets around database names containing special characters such as a hyphen in sync script.
1001	All	All	Schema: Timestamp year entry is incorrect for archives when regional time setting is set to YYYY-DD-MM.
1006	SQL Server	All	"Schema: When adding a identity column to existing table, the SET_IDENTITY_INSERT stmt needs to be set to OFF instead of ON."
1008	SQL Server	All	Schema: problems opening HTML report scripts for objects with long names
1009	SQL Server	All	"Schema: Support for new MS SQL Server 2005 datatypes - User should be able to create varchar(max), nvarchar(max), varbinary(max)."
1012	SQL Server	All	Schema: Extra code is generated during compare.
1015	Oracle	All	Schema: ISQL: Errors executing CM Sync DDL - Successful using DBArtisan ISQL.
1017	All	All	Schema: Upgrade script fails when using named SQL Server Instance (SQLSERVER\INSTANCE).
1019	SQL Server	All	Schema: SCHEMA_CAPTURE: Exception list to exclude number of Stored Procedures for comparison.
1020	SQL Server	All	Schema: SQL2005: Tablename entry missing from 'sp_rename' calls within syncronise script.
1022	SQL Server	All	Schema: Extraction for Logins are different in Change Manager and Dbartisan.
1023	All	All	Schema: Change Manager does not work with Lotus Notes.
1026	All	All	Schema: Unable to execute parallel archive executions.
1027	All	All	Schema: COMPARISON_REPORT: HTML contains back slash characters for A HREF links which fails to work on Apache Web Server.
1028	SQL Server	All	Schema: Application crashes with a buffer overrun when it tries to compare archive views between SQL2K and SQL 2005 (same job worked fine in CM303).
1029	SQL Server	All	Schema: SCHEMA_COMPARE: Critical error when comparing two MSSQL databases.
1032	Oracle	All	"Schema: ORA_10.2: Error ""Send Mail failed to send message"" when sending (SMTP) Comparison HTML report."
1033	Oracle	All	Schema: Generated Create Index statements don't include columns after sync.
1035	DB/2	All	"Schema: When comparing an archive to a live db2 udb datasource, CM creates a drop/create script even if it appears to be no differences."
1038	SQL Server	All	Schema: Error of Invalid Synchronization SQL directory when name of database has a (/) dash in it.
10All2	Oracle	All	Schema: SCRIPT: Partition value (DEFAULT) being incorrectly generated as ('DEFAULT') causing syntax error when executed.
1033	Oracle	All	"Schema: SQL: Index not dropped when using Primary key with index (only Constraint is dropped), causing run-time error."
1035	Oracle	All	Schema: COMPARE: Differences not detected when source table is part. with sub-part and target table is identically part. without sub-part.
1036	All	All	"Schema: After running a query on CM All.0, gets a incorrect syntax error message."
1055	All	All	Schema: TS: Sync script should contain DROP statement and not set them to UNUSED.
1057	Oracle	All	Schema: Semi Colon (;) causing compile errors in Change Manager.
1058	SQL Server	All	Schema: Archive Version states All instead of All.0 for a newly created archive.
1060	All	All	Schema: SYNC_SCRIPT contains incorrect Schema name for ALTER INDEX.
1061	Sybase	All	Schema: Logical FK's skipped when extract SQL from archive.
1099	All	All	"Schema 5.0: When doing an extended alter, no need to drop table constraints first."
1303	Sybase	All	Data: Default naming scheme option is disabled by default during datasource Auto Discovery and is later causing bad SQL script names.
1311	All	All	Data: Selecting a single table to compare hangs the product.
1353	All	All	Data: An user defined data type and a system data type can't be mapped for MS SQL Server 2005.
1693	Oracle	All	Schema 5.0: Extra lines being added which are casuing issues error message when you try to compile when extracting an archive.
1835	SQL Server	All	Schema 5.0: Column default value comparison fails SQL Server 2000 vs. 2005.
1858	All	All	Data: Option to print out data comparison reports.
1950	All	All	Data: No columns for certain Oracle 10 mappings.
2121	All	All	Data: DATE data type for Oracle is not shown completely in CM Database results page.
2133	All	All	Schema 5.0: Generates incorrect sync script for index.

Additional Resources

Licensing Your Embarcadero Technologies Product

This product includes a 30-day 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, FAQs, discussion groups, and the Embarcadero KnowledgeBase.

Go to 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 (1All days).

We encourage you to open technical support cases via the Technical Support request form at the Embarcadero Technologies Web site. For additional information about Embarcadero Technologies Technical Support, go to the Support page on 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.