Get documents about "Database Change Management
Description
Change Manager is a powerful set of tools for database administrators and developers to simplify and automate the database change management lifecycle.
Document Sample
Change Manager 5.1 Beta Program
What’s New in Change Manager
We are currently recruiting Beta Program participants. If you would like
to participate, please speak to your Account Representative or register Data Masking
online at: https://beta.embarcadero.com/ Change Manager 5.1 Ultimate Edition now includes the ability to mask
data in the data comparison job with auto-synchronization. Support is
built on technology from DT/Studio and supports randomization and
New Features at a Glance shuffling:
Improvements in schema, data, and the general functionality.
• Auto-Synchronization options on the data comparison (using the Randomization: each value from the source database is inspected and a
DT/Engine) and schema comparison jobs to make the target match corresponding new value is added to the target. For the case of a string
the source when the job is run value, a random alpha numeric of the same length is generated.
“Gordon” might become “Ztsajw” for example.
• Data Masking: shuffle or randomize columns in a data comparison
with auto-synchronization job
Shuffling: values on the source are randomly assigned to different rows
• Unicode support on the target. This preserves the set of data on the source but removes
• Cross-DBMS platform schema comparison between Oracle and the connection between the data in a row.
SQL Server, and Sybase and SQL Server
• Data comparison job history, track high level results of previous Steps to Get Started
data comparison jobs on a new history page in the data 1. Create a Data Comparison Job
comparison job editor 2. Turn on Auto Synchronization in the Options Tab
• Project support allows users to group jobs and results into named 3. On the Mapping Tab, assign masking rules at the database, table,
groupings, each of which can be independently connected with and column level
source code control repositories via Eclipse plug-ins provided by 4. Run the Job
third parties
• Reworked schema comparison results: actions and comparison NOTE: In 5.1 Change Manager is unable to mask columns that are part
outcomes clearly enumerated, quick-type filtering, counts of of a primary and foreign keys. This will be available in an upcoming
resolution types, clearer layout release.
• Email notification enhancements including a test button in the
configuration setup and contact imports/exports Cross-DBMS Platform Schema Compare & Sync
• Integrates with DB Optimizer and Rapid SQL Developer in the Migrate, compare, and synchronize schemas between database
same shell platforms using a schema comparison job with source and target of
various types.
• Updated data comparison mapping page adding high level alerts
and warnings when mappings are invalid and incomplete, set
custom warning levels for situations such as length mismatches, Now Change Manager Professional and Ultimate editions can compare
constraints on the target, and precision/scale differences and sync Oracle with SQL Server as well as Sybase with SQL Server:
5.1 Release Schedule DB2 for LUW Oracle SQL Server Sybase
DB2 for LUW
Release Date Oracle
Beta May 12, 2009 SQL Server
Internal Unicode Ready Release May 19, 2009 Sybase
Beta 2 with Unicode May 26, 2009
GA June 24, 2009 The supported objects for cross platform schema comparisons are:
• Views
Supported Database Systems • Tables
• IBM DB2 for LUW v8, v9, v9.5
• Check Constraints
• Oracle 8i, 9i, 10g, 11g
• Foreign Keys
• SQL Server 2000, 2005, 2008
• Indexes
• Sybase ASE 12.5, 15, 15.0.1, 15.0.2
• Primary Keys
• Unique Keys
Technical Requirements
Auto-Synchronization
• 1.2 Ghz processor with 1 GB of RAM
Both data comparison and schema comparison jobs have new options to
• 1 GB disk space auto-synchronize. If enabled, a successful comparison will automatically
• 1024 x 768 16-bit display synchronize the target to match the source. Reports and results are
• Windows® XP Professional, Windows Server 2003, Windows Vista configured to show the outcome of the synchronization. Data
(Ultimate and Business) – 32-bit architecture only, Red Hat synchronization wipes the target database’s data and repopulates from
Enterprise Linux 5.0, x86-32, GTK 2 or SUSE Linux Enterprise Server the source through DT/Engine technology.
(x86) GTK+ 2.x
Corporate Headquarters | Embarcadero Technologies | 100 California Street, 12th Floor | San Francisco, CA 94111 | www.embarcadero.com |
sales@embarcadero.com
© 2009 Embarcadero Technologies, Inc. Embarcadero, the Embarcadero Technologies logos, and all other Embarcadero Technologies product or service names are trademarks or registered trademarks of
Embarcadero Technologies, Inc. All other trademarks are property of their respective owners.
Change Manager 5.1 is Easier to Use
Change Manager 5.1 introduces usability enhancements to make it easier to learn and get started and to provide clearer results and action plans for
schema and data comparison jobs.
A new Welcome dialog includes steps and tutorials for getting started with basic tasks, shows recently changed jobs, recently run jobs, and provides
quick actions to jump right to creating a new job.
A new wizard bar walks users through configuring jobs with a Finish button suggesting next steps:
The schema comparison results page has a completely new layout, separating comparison status with the suggested action, organizing the actions and
filters, new counts of action types (number of extended alters, drops, etc.), quick-type filtering to find objects, and a detailed exportable report for an
object of what internals Change Manager matched and/or did not match.
The data comparison mapping page now shows high level status markers for incomplete mappings and allows for customization of how severe various
scenarios should be considered: no comparison key, column data types are incompatible, table dependency cycles, target length is shorter, and so on.
Schema Object Support
Support for a platform does not necessarily indicate that every object on that platform can be managed using Change Manager’s schema jobs. Refer to
the tables below for object support, and forward any requests or feedback to development. The objects supported by 5.1 have not changed but the
depth and accuracy of support is improved for many objects and platforms.
DB2 for LUW Oracle SQL Server Sybase
Server Objects Server Objects Server Objects Server Objects
Buffer Pools Directories Databases Data Caches
Event Monitors Groups Linked Servers Database Devices
Groups Profiles Logins Databases
Node Groups Redo Log Groups Remote Servers Dump Devices
Tablespaces Roles and Users Server Triggers Logins
Users Rollback Segments User Messages Remote Servers
Database Objects Tablespaces Database Objects Roles
Aliases Database Objects Asymmetric Keys Database Objects
Check Constraints Check Constraints Certificates Aliases
Foreign Keys Clusters Check Constraints Check Constraints
Functions Database Links Defaults Defaults
Indexes Foreign Keys Extended Procedures Extended Procedures
Materialized Query Tables Functions Foreign Keys Foreign Keys
Primary Keys Indexes Functions Indexes
Procedures Java Sources Indexes Logical Foreign Keys
Sequences Libraries Primary Keys Logical Primary Keys
Structured Types Materialized Views and Logs Procedures Primary Keys
Tables Outlines Roles Procedures
Triggers Packages and Bodies Rules Rules
Unique Keys Primary Keys Server Triggers Segments
User Defined Types Procedures Symmetric Keys Tables
Views Sequences Synonyms Triggers
Synonyms Tables Unique Keys
Tables Triggers Users
Triggers Unique Keys User Messages
Types and Bodies Users User Defined Datatypes
Unique Keys User Defined Datatypes Views
Views Views
XML Schemas
Database Permissions
Change Manager requires data source credentials to have certain levels of permission in order to run schema, configuration, and data jobs. The table
below summarizes the required permissions. Please refer to Change Manager Minimum Permission Requirements for more detailed information.
Task DB2 for LUW Oracle SQL Server Sybase
Archive and Coming SELECT_CATALOG_ROLE for No special permission required No special permission required
Compare Schemas Soon objects not owned by current
user
Alter Schema Coming None for own objects None for own objects None for own objects
Objects Soon “DBA” role to alter system sysadmin and sp_configure “allow sa_role and sp_configure
objects updates” to modify system objects (not “allow updates” to modify
allowed in 2005) system objects
Configuration Coming “DBA” role sysadmin sa_role
Settings Soon
Compare Data Select privilege on the tables/views involved and permission to archive the tables, views, indices, and keys involved (see
archive and compare schemas above)
Synchronize Data Insert/Update/Delete privileges on the tables/views involved
Corporate Headquarters | Embarcadero Technologies | 100 California Street, 12th Floor | San Francisco, CA 94111 | www.embarcadero.com |
sales@embarcadero.com
© 2009 Embarcadero Technologies, Inc. Embarcadero, the Embarcadero Technologies logos, and all other Embarcadero Technologies product or service names are trademarks or registered trademarks of
Embarcadero Technologies, Inc. All other trademarks are property of their respective owners.
