DB Change Manager Home
| DB Change Manager Documentation
| Technical Support | www.idera.com
ReadMe
Last Published: December 6, 2022. Any updates to these notes are 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 18.3
Updates Azure cloud
monitoring capability in DBArtisan
Supports the latest
version of Log4j
Improves multiple
areas within DBArtisan and Rapid SQL
Improves
multiple areas within DB Change Manager
Updates profiling
session capability in DB Optimizer
What's New in DB Change Manager 18.2
No new features or fixed
issues in Change Manager, but simply a version revision
What's New in DB Change Manager 18.1
No new features, but there
are some fixed issues in DB PowerStudio
Requirements
Release Notes
Additional Resources
What's New in DB Change Manager 18.3
Updates Azure cloud
monitoring capability in DBArtisan
The monitoring capability for Microsoft Azure
cloud is updated in DBArtisan. This functionality includes multi-tabbed process
monitoring and management as well as allows you to catch performance issues
before they arise.
Supports the latest version of Log4j
DB PowerStudio 18.3 includes support for the
latest version of Apache Log4j, which is essential for proper logging and
diagnostics of applications.
Improves multiple
areas within DBArtisan and Rapid SQL
DB PowerStudio 18.3 includes updates to the
following areas within DBArtisan and Rapid SQL:
Improves multiple
areas within DB Change Manager
Updates profiling session capability in DB
Optimizer
DB Optimizer 18.3 updates profiling session
capability, which alerts users to potentially problematic SQL ahead of time.
What's New in DB Change Manager 18.2
There are no new features in this release of DB
Change Manager. This release is simply a version revision. For more information
about this release, see http://wiki.idera.com/display/DCM/Release+notes.
What's New in DB Change Manager 18.1
There are no new features in this release of DB
Change Manager, but there are some fixed issues in DB PowerStudio. For a recent
list of fixed issues in this release, see http://wiki.idera.com/display/DCM/Release+notes.
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 cloud platforms:
·
Microsoft SQL Database
Supported
Database Platforms
DB Change Manager is supported on the following DBMS platforms and
versions:
* DB Change Manager supports only a subset of
features and functions for this database version.
** Support for this version
is nearing end of life and may not be available in subsequent DB Change Manager
releases.
Release Notes
·
DB Change Manager 18.3 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),
16.6, 17.0, 17.1, 18.0, 18.1, and 18.2 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.
·
Beginning with version 17.0, DB Change Manager 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 the latest version of DB Change
Manager.
NOTE: You do not have to upgrade to 5.6, and then to the latest version
of DB Change Manager. 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) and
later
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, 17.0, 17.1, 18.0, 18.1, or 18.2.
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 18.x 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 the latest installed version of DB Change Manager.
Upgrading
from Version CMSchema 4.0 or CMData/Config 4.0 to the latest version of DB
Change Manager
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) and later.
For the more recent list of known issues and bug
fixes in this release, see http://wiki.idera.com/display/DCM/Release+notes.
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 sales@idera.com.
The IDERA Web site is an excellent source for additional product
information, including white papers, articles, and discussion forums. Visit 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.