Embarcadero DB Change Manager XE2

Features

For database administrators

Roll out database changes more easily:

• Use a live-to-live database compare as a basis for obtaining a list of changed objects, and a change script to roll the changes forward
• Capture a snapshot of the target before you roll changes forward, so that you can roll back a schema change if necessary
• Deep support for DB2 for LUW, Oracle, SQL Server and Sybase leverages DBMS-specific features, objects, options, and syntax.

Easily reveal how a database has changed since a point in time and track and report on changes:

• Reveal and report on changes to packaged application databases resulting from vendor patches or customisation
• Uncover abnormalities in the database that result from improper change, which might impact production performance or functionality
• Notify yourself or your colleagues when a particular portion of the database has changed: for example tables for data modelers, stored procedures for developers, etc.

Comply with Database Audit and Reporting Requirements:

• Identify and report on changes to the database at or between points in time, or to particular sensitive objects: ad hoc or on a regular basis
• Audit database configurations against established standards to minimise the vulnerability of your databases.

Protect Data Privacy:

• Shuffle or randomise columns in a data compare with auto-synchronisation job
• De-identify data in the production environment and quickly migrate the masked, yet realistic and fully functional, data into Development, Test and QA environments.

For developers, development managers and QA

Use DB Change Manager XE2 to help streamline and accelerate your development cycles:

• Track and communicate database changes with modelers, DBAs and other developers
• Integrates with source code control (SCC) software to correlate schema change with application code changes by linking an archive with version of the application within the SCC repository
• Archive modified stored procedures, tables, indexes, etc., and report on the modifications using the scheme compare functionality
• Associate a change request with a set of database objects that have changed
• Manage your reference data via live-to-live data compare, and report on reference data changes.

Validate synchronicity between development and QA environments:

• Ensure the integrity of your structures and reference data before you begin testing
• Ensure that development and QA match production: that no changes to production have occurred that would otherwise escape your attention.

Streamline common development and QA tasks:

• Easily generate change scripts, for changes to modified schema and dependent objects
• Capture your database objects at points in time, so that you can report on, or roll back to a particular state in time for just that object, or for an entire schema
• Use data compare as a basis for comparing expected to actual results
• Manage your reference data.

Editions

DB Change Manager XE2 Developer

• Support for all database platforms included
• Embarcadero ToolCloud licence technology
• InstantOn
• Centralised licence management
• Schema archive snapshot
• Database schema compare - live to live, live to archive and archive to archive
• Live to live data compare across tables and schemas
• SQL editor
• Source code control integration
• Reporting capabilities with export to HTML, PDF, XML, CSV & RTF

DB Change Manager XE2 Professional

Additionally includes:

• Email notifications
• Unlimited data source connections
• Advanced object management and across DBMS schema compare
• Data masking
• Audit and compliance reporting of database configuration settings

DB Change Manager XE2 Enterprise

Additionally includes:

• Command line API for job scheduling.

System Req.

DB Change Manager XE2 System Requirements

• 1.2 Ghz processor
• 1GB of RAM
• 500 MB disk space
• 1024 x 768 16-bit display
• Internet Explorer 6 SP1
• Windows XP Professional, Windows Server 2003, Windows Vista (Ultimate and Business), Windows 7 (32-bit and 64-bit architecture).

Please note: the following operating systems are not supported in the 6.0/XE2 release: Red Hat Enterprise Linux 5.0, x86-32, GTK 2 or SuSe Linux Enterprise Server (x86) GTK+ 2.x.