DB Change Manager Home
| DB Change Manager
Documentation | IDERA Technical
Support | www.idera.com
Any
updates to these notes will be available at https://www.idera.com/support/productdocuments.
Thank
you for using IDERA 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 17.0.2
What's New in DB Change Manager 17.0.0
Removed Support for InterBase,
Firebird
Removed Auto-Update and Install New Software
features from Help Menu
Requirements
Release Notes
Additional Resources
What's New in
DB Change Manager 17.0.2
DB Change Manager 17.0.2 is simply an update to the version number.
What's New in DB Change Manager 17.0.0
Updated Licensing
DB Change Manager includes a new licensing process to bring it
into standard with the rest of the DB PowerStudio
products.
The installer for DB Change Manager now:
·
verifies that a supported version of Windows OS exists on the
machine before continuing with the installation
·
offers offline .MSI files for installation
Removed
Support for Interbase, Firebird
DB Change Manager no longer
supports InterBase or Firebird.
Removed
Auto-Update and Install New Software features from Help Menu
This version of DB Change Manager
includes an update Help Menu that no
longer includes Auto-Update and Install New Software options.
Requirements
DB
Change Manager requires the following:
Supported Operating Systems
DB Change Manager is supported on the following operating systems
(32- and 64-bit):
DB Change Manager is supported on the following DBMS platforms and
versions:
* For these databases,
DB Change Manager supports a subset of this database version’s
features/functions.
Release Notes
·
DB Change Manager 17.0 should be installed in a different
directory than 4.x, 5.x, 6.0.x, 6.1, 6.2, 6.3.x, 2016 (6.3.3), 2016+ (16.5),
and 16.6 versions. If DB Change Manager is installed in the same directory, the
following error will result at application start up: "Unable to read
workbench state. Workbench UI layout will be reset."
·
If one of the
conflicting versions is already installed on your machine, either change the
default Workspace or delete all files from the Workspace directory. The
Workspace directory location appears whenever you start DB Change Manager and
can be redefined from this dialog box. If the same Workspace is indicated for
the new version, as was indicated previously, the following error will result:
"Cannot restore workbench layout."
·
If DB Change Manager is already running, you can also modify the
Workspace directory by choosing File > Switch Workspace > Other
from the Main menu.
·
The format in which
schema comparisons are saved has changed in 6.x. Use the import feature to
import pre-6.0 schema comparison jobs.
·
DB Change Manager 17.0 provides an upgrade process for moving jobs
and other information from an existing DB Change Manager 4.0, 5.0, 5.1.x, 5.5.x
or 5.6 installation. No upgrade process is required to move from 6.x installations
to DB Change Manager 17.0.
NOTE: You do not have to upgrade to 5.6, and then to DB Change Manager
17.0. The import procedure is the same.
Upgrading
from Version 5.0, 5.1.x, 5.5.x or 5.6 to DB Change Manager 2016 (6.3.3), 2016+
(16.5), 16.6, or 17.0
All
objects can be imported from version 5.0, 5.1.x, 5.5.x or 5.6 to DB Change
Manager 2016 (6.3.3), 2016+ (16.5), 16.6, or 17.0.
To
upgrade from 5.0, 5.1.x, 5.5.x or 5.6:
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 17.0 in a different directory than the previous installation.
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:
o Select File > Import.
o Select Change Manager Workspace from the
IDERA group and click Next.
5.
Select the version of DB
Change Manager from which to import.
6.
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 DB Change Manager version. Click Next to
continue through each step of the wizard.
8.
Click Finish. The
jobs are imported to DB Change Manager 17.0.
Upgrading
from Version CMSchema 4.0 or CMData/Config 4.0 to DB Change Manager 17.0
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 from CM Schema 4.0:
1.
To import schema
comparison jobs from 4.0, obtain and install cmschema_40_932_upgrade.exe
from your IDERA Technical 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, 5.1.x,
5.5.x or 5.6 to DB Change Manager 2016 (6.3.3), 2016+ (16.5), 16.6, or 17.0.
Bug |
Description |
DBMS |
SC-14764 |
Errors coming up for
schema comparison job movies_dev to movies_prod |
Oracle |
SC-14757 |
Configuration compare
job save does not work – lose all work. |
Oracle |
SC-14760 |
“Data source name
cannot exceed more than 30 characters” in Change Manager and DBOptimizer. |
|
SC-14626 |
NullPointer exception while generating report once Schema Archive Job
completed |
|
There are no bug fixes
included in DB Change Manager 17.0.2.
Customer-reported bugs
fixed for the DB Change Manager 17.0.0 release:
Bug |
Description |
DBMS |
SC-14729 |
DBCM displays a dialog
during shutdown due to null pointer error |
|
SC-14728 |
DBCM displays a dialog
during shutdown due to thread error |
|
SC-14725 |
DBCM hangs when
shutting down and having to save a data mask job |
There are no bug fixes
included in DB Change Manager 16.6.1.
Customer-reported bugs
fixed for the DB Change Manager 16.6 release:
Bug |
Description |
DBMS |
SC-14615 |
[Data comparison] SQL
2014 databases are not populated |
SQL Server |
SC-14533 |
Support for DB2 for
LUW 10.5 |
DB2 for LUW |
SC-14716 |
Database drop-down
list is grayed out on Target datasource |
Sybase ASE |
There are no bug fixes
included in DB Change Manager 2016+ (16.5).
Customer-reported bugs
fixed for the DB Change Manager 2016 (6.3.3) release:
Bug |
Description |
DBMS |
SC-14595 |
Schema Compare -
Triggers and Logical Foreign Keys failures. |
Sybase ASE |
SC-14594 |
Column Width Archive
Issue. |
SQL Server |
SC-14591 |
Identity Columns are
not correctly Extracted when Archiving a Database. |
SQL Server |
SC-14584 |
Schema archive job
creates incorrect SQL for a view with column level permissions. |
Sybase ASE |
SC-14580 |
Schema Comparison -
SYS.INSERT_TSN_LIST$ is not found in some cases. |
Oracle |
SC-14567 |
Case # 00425065:
Schema Compare - Missing Comparison Configurations. |
Oracle |
SC-14565 |
Owners are not
populated in refinements tab. |
Oracle |
SC-14553 |
Case # 00413533 - Table
difference being reported when there are no differences. |
Oracle |
SC-14547 |
Ability to include
> 10000 objects in a Schema Report. |
All |
SC-14524 |
Schema archive job
creates incorrect SQL for a view with column level permissions. |
Sybase ASE |
Customer-reported bugs fixed for the DB Change
Manager 2016 (6.3.1) release:
Bug |
Description |
DBMS |
SC-14489 |
Linux - Error when
generating configuration archive report. |
All |
SC-14490 |
Incorrect order of
statements in the Synch Script. |
SQL Server |
SC-14491 |
Support to ignore
object comments for SQL Server on schema comparison. |
SQL Server |
SC-14495 |
Data-synch job start
but makes no progress after 4+ hours. |
SQL Server |
SC-14498 |
Automatic sync - The
progress between sync summary and sync results is not the same. |
MySQL |
Customer-reported bugs fixed for the DB Change
Manager 2016 (6.3) release:
Bug |
Description |
DBMS |
SC-14281 |
[Schema Comparison
Job] Procedures showing "Don't Match" but when click View
Differences, there are no differences. |
Sybase |
SC-14289 |
[Schema Comparison
Job] when there is an ALTER procedure after the creation. ANSI_NULLS and
QUOTED_IDENTIFIER have been turned off. |
SQL Server |
SC-14463 |
[MSSQLServer]
Length of User Defined Datatype in Database Objects is twice [nchar nvarchar]. |
SQL Server |
SC-14470 |
Incorrect comparison
of User Defined Types. |
SQL Server |
Additional
Resources
All IDERA products include a 14-day trial period. To continue using
the product without interruption, we recommend that you license it as soon as
possible. For information on licensing your product, refer to the Quick
Start Guide. If you have not yet purchased this product, contact [email protected].
The IDERA Web site is an excellent source for additional product
information, including white papers, articles, discussion forums, and the IDERA
Knowledge Base. Visit www.idera.com/support,
or click any of the links below, to find:
If you have a valid maintenance contract with IDERA, the Technical
Support team is available to assist you with any problems you have with our
applications. Our maintenance contract also entitles registered users of IDERA
products to download free software upgrades during the active contract period.
Evaluators receive free technical support for the term of their evaluation (14
days).
We encourage you to open technical support cases via the Customer Support Center. For
additional information about IDERA Technical Support, visit the Support section of our Web site.
To download evaluations of other IDERA products or to learn more
about our company and our products visit us at www.idera.com.