[제품 개요]
DB Change Manager™ XE는 데이터베이스 관리자 및 개발자들의 데이터베이스 변경
관리 업무를 단순화하고 자동화해주어 개발을 효율화할 수 있게 해주고 가용성과 성능, 표준 준수를 보장해줍니다.
• 데이터베이스 변경 관리 업무를 단순화 및 자동화
• 개발 사이클을 Streamline
• 가용성, 성능, 표준 준수를 보장
XE 제품군은 다른 데이터베이스 변경 관리 솔루션에서는 찾아볼 수 없는 가장 경쟁력 있는 가격에 독자적인 이점들을 제공합니다.
• 단일 제품, 단일 가격, 단일 라이선스로 모든 DBMS들을 단일 화면에서 지원하는 진정한 이기종 툴입니다.
• Embarcadero® InstantOn™으로 로컬에 인스톨하지 않고 실행할 수 있으며, 동시에 여러 버전들을 사용할
수 있습니다.
• Embarcadero® ToolCloud™로 중앙집중적인 라이선스 관리와 툴 배포가 가능합니다.
DB Change Manager XE의 비교, 동기화, 데이터 마스킹, 감사 기능들은 변경 사항들을 추적하고 보고할 수 있게 해주며, 데이터나
스키마, 혹은 데이터베이스 설정 수준의 변경으로부터 초래된 성능 문제를 정확히 찾아낼 수 있게 해줍니다. 운영중인 데이터베이스를 스키마/설정
"스냅샷"과 비교할 수 있음으로써, 관리자들은 병경 내용을 빠르게 알아채고 짧은 시간 내에 문제를 정정할 수 있게 됩니다. 또한 데이터베이스
설정들을 모니터링함으로써 DBA들은 법적 규제들과 성능 표준들을 준수하면서도 전반적인 데이터베이스 성능과 가용성을 유지할 수 있게 됩니다.
[Features]
• Compare Live Schema Objects
• Compare Archive Snapshots of Schema Objects
• Generate ALTER, CREATE and DROP .DDL scripts for selected schema
differences
• Command line interface allows users to automate tracking and
reporting on database changes
• Provide schema change reports in multiple formats (.csv, .xml,
.html, .pdf, .rtf)
• Data Compare assists in comparison, synchronization and
validation of user data
• Generate .DML scripts for INSERT, UPDATE and DELETE operations
detected during data comparison
• Audit and Compliance reporting for database configuration
properties
• Integration with industry standard version control providers
• Deep native schema object and data comparison functionality for:
◦ Firebird 1.5, 2.0
◦ IBM DB2 for LUW v8, v9, and v9.5
◦ InterBase 2007, 2009
◦ Oracle 8i, 9i, 10g, and 11g
◦ SQL Server 2000, 2005, 2008 and 2008r2 Sybase ASE
12.5 , 15, 15.0.1 and 15.0.2
• Centralized license management and tool deployment with
Embarcadero ToolCloud
스키마 비교 및 동기화
•
라이브-라이브, 라이브-아카이브, 아카이브-아카이브, 단일-복수 비교 가능
• 고급 alter 생성
• 5.1 버전 신기능! 이기종 DBMS 스키마 비교 및 동기화
설정 표준들을 모니터링
• 데이터베이스 설정 값과 범위에 대한 기대치를 정의하고, 준수 여부를
확인하기 위한 비교 작업을 실행할 수 있음
데이터 비교 및 동기화
• 테이블 단위 혹은 전체 스키마에 대해 테스트 데이터나 레퍼런스
데이터를 비교
• 차이점과 동기화 변경 사항에 대한 리포트
Data Auto-synchronization - DB Change Manager
will automatically truncate the target data as data from the source is streamed
to the target.
Data Masking - Shuffle or randomize columns
to de-identify data. Read more about DB Change Manager’s data masking
capabilities: Protecting Data Privacy in the Development Lifecycle.
Schema Auto-synchronization - Automatically
synchronize the target to match the source once there is a successful
comparison.
Cross-DBMS Schema Compare - Schema comparison
and synchronization between Oracle <> SQL Server and Sybase ASE <> SQL Server
Job History - Track previous comparison runs
and reload results to generate synchronization scripts and results
Full Unicode Support - DB Change Manager 5.1
provides full Unicode character support.
Enhanced project support - Users can group
jobs and results into named groupings, each of which can be independently
connected with source code control repositories via Eclipse plug-ins provided by
third parties
New in 5.1.1 - InterBase 2007, 2009 and
Firebird v1.5 and 2.0 Support
[제품 장점]
<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 customization
• 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 minimize
the vulnerability of your databases
Protect Data Privacy
• Shuffle or randomize columns in a data compare with
auto-synchronization 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