Difference between revisions of "Benchmark Extension Systems"
Line 4: | Line 4: | ||
=== Open Source === | === Open Source === | ||
+ | |||
+ | ==== Liquibase ==== | ||
+ | [http://www.liquibase.org/manual/home Liquibase] is an open source (LGPL), DBMS-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes (structure and data) are stored in an XML-based descriptive manner and checked into source control. | ||
+ | {| border="1" | ||
+ | ! !! Document !! Predictability !! Transformation !! Reversibility | ||
+ | |- | ||
+ | ! Schema | ||
+ | | DBDoc || Change log & Diff || Yes || lose-less operation | ||
+ | |- | ||
+ | ! Data | ||
+ | | DBDoc || Change log & Diff || Yes || lose-less operation | ||
+ | |- | ||
+ | ! Query/Update | ||
+ | | N/A || SQL Output || N/A || N/A | ||
+ | |- | ||
+ | ! Other Objects | ||
+ | | DBDoc || Change log & Diff || Yes || lose-less operation | ||
+ | |} | ||
+ | |||
+ | ==== ==== | ||
+ | |||
+ | ==== Python Migration Packages[http://pypi.python.org/pypi/] ==== | ||
+ | Some packages support reversibility, but most of them are not. | ||
+ | {| border="1" | ||
+ | ! !! Document !! Predictability !! Transformation !! Reversibility | ||
+ | |- | ||
+ | ! Schema | ||
+ | | Probably || N/A || Yes || few of Packages | ||
+ | |- | ||
+ | ! Data | ||
+ | | Probably || N/A || Yes || few of Packages | ||
+ | |- | ||
+ | ! Query/Update | ||
+ | | N/A || N/A || N/A || N/A | ||
+ | |- | ||
+ | ! Other Objects | ||
+ | | N/A || N/A || Probably || N/A | ||
+ | |} | ||
+ | |||
+ | ==== Ruby on Rails Migration Packages[http://wiki.rubyonrails.org/rails/pages/ActiveRecordMigration] ==== | ||
+ | {| border="1" | ||
+ | ! !! Document !! Predictability !! Transformation !! Reversibility | ||
+ | |- | ||
+ | ! Schema | ||
+ | | Probably || N/A || Yes || N/A | ||
+ | |- | ||
+ | ! Data | ||
+ | | Probably || N/A || Yes || N/A | ||
+ | |- | ||
+ | ! Query/Update | ||
+ | | N/A || N/A || N/A || N/A | ||
+ | |- | ||
+ | ! Other Objects | ||
+ | | Probably || N/A || Probably || N/A | ||
+ | |} | ||
+ | |||
+ | ==== Cake DB Migration[http://bakery.cakephp.org/articles/view/cake-db-migrations-v2-1] ==== | ||
+ | Similar to Ruby on Rails Migration. It is coded by PHP. | ||
+ | |||
+ | === Academic === | ||
+ | |||
=== Industrial === | === Industrial === | ||
Line 100: | Line 161: | ||
|} | |} | ||
− | ==== RedGate SQL Solutions ==== | + | ==== RedGate SQL Solutions (multiple solutions) ==== |
[http://www.red-gate.com/products/SQL_Compare/index.htm RedGate SQL Compare] is the industry-standard tool for comparing and synchronizing SQL Server database schemas. It's used by over 150,000 developers, DBAs and test engineers worldwide because it's easy to use, it's fast, and it saves time. | [http://www.red-gate.com/products/SQL_Compare/index.htm RedGate SQL Compare] is the industry-standard tool for comparing and synchronizing SQL Server database schemas. It's used by over 150,000 developers, DBAs and test engineers worldwide because it's easy to use, it's fast, and it saves time. | ||
[http://www.red-gate.com/products/SQL_Data_Compare/index.htm RedGate SQL Data Compare] is used for automating data migrations, analyzing corrupted data, restoring row-level data from backups and compiling audit trails of missing or changed data. It's the industry standard tool for comparing and synchronizing the contents of two databases because it's very reliable and also very fast. | [http://www.red-gate.com/products/SQL_Data_Compare/index.htm RedGate SQL Data Compare] is used for automating data migrations, analyzing corrupted data, restoring row-level data from backups and compiling audit trails of missing or changed data. It's the industry standard tool for comparing and synchronizing the contents of two databases because it's very reliable and also very fast. | ||
Line 125: | Line 186: | ||
[****] SQL Refactor | [****] SQL Refactor | ||
− | ==== SwisSQL ==== | + | ==== Best SoftTool SQL DB Compare ==== |
+ | [http://bestsofttool.com/SQLDBCompare/SDC_Feature.aspx SQL DB Compare] is a robust database schema/data comparison and synchronization tool for SQL Server databases. It provides you great ease and productivity to manage SQL Server database development and production maintenance. | ||
+ | {| border="1" | ||
+ | ! !! Document !! Predictability !! Transformation !! Reversibility | ||
+ | |- | ||
+ | ! Schema | ||
+ | | ? || Yes || Yes || ? | ||
+ | |- | ||
+ | ! Data | ||
+ | | ? || Yes || Yes || ? | ||
+ | |- | ||
+ | ! Query/Update | ||
+ | | ? || N/A || N/A || N/A | ||
+ | |- | ||
+ | ! Other Objects | ||
+ | | ? || Yes || Yes || ? | ||
+ | |} | ||
+ | |||
+ | ==== Toad® DBA Suite ==== | ||
+ | [http://www.quest.com/toad-dba-suite-for-oracle/ Toad® DBA Suite] is a bundle comprised of four tools that simplify common database administration tasks and help you become more proactive in solving database-related performance issues before they impact the production environment. As a database administrator (DBA), you have to be more versatile than ever before. That's because you are under constant pressure to implement application and database changes and quickly resolve problems, while preventing data loss or corruption. Plus, you must manage a variety of toolsets, while meeting service levels for performance and availability. | ||
+ | {| border="1" | ||
+ | ! !! Document !! Predictability !! Transformation !! Reversibility | ||
+ | |- | ||
+ | ! Schema | ||
+ | | ? || ? || Yes || ? | ||
+ | |- | ||
+ | ! Data | ||
+ | | ? || ? || ? || ? | ||
+ | |- | ||
+ | ! Query/Update | ||
+ | | N/A || N/A || N/A || N/A | ||
+ | |- | ||
+ | ! Other Objects | ||
+ | | ? || ? || Probably--Yes || ? | ||
+ | |} | ||
+ | |||
+ | ==== Aldon Change Management Software ==== | ||
+ | [http://www.aldon.com/solutions/standards/database.aspx Aldon Lifecycle Management Solution] brings process management, quality and predictability to database application development. Aldon's database change solution manages database and application code in a unified environment, greatly simplifying code development across multiple databases on multiple platforms. Database development can be easily integrated with application development using the Aldon database change and source management solution. | ||
+ | |||
+ | ==== Altova Schema Agent ==== | ||
+ | [http://www.altova.com/products/schemaagent/xml_schema_management.html Altova SchemaAgent® 2008] is the visionary tool for analyzing and managing relationships among XML Schemas, XML instance documents, XSLT files,and WSDL files, as well as viewing files used in Altova MapForce data mapping projects – across a project, an intranet, or even an enterprise. It allows you to visualize and manage XML file relationships easily via its graphical design view, and create new relationships using drag-and-drop functionality to automatically configure imports, includes, and/or redefines (IIRs). | ||
+ | |||
+ | ==== DTM Database Suite (multiple solutions) ==== | ||
+ | [http://www.sqledit.com/products.html DTM Database Suite] | ||
+ | |||
+ | {| border="1" | ||
+ | ! !! Document !! Predictability !! Transformation !! Reversibility | ||
+ | |- | ||
+ | ! Schema | ||
+ | | ? || DTM Schema Comparer || DTM Migration Kit || ? | ||
+ | |- | ||
+ | ! Data | ||
+ | | ? || DTM Migration Kit || DTM Migration Kit || ? | ||
+ | |- | ||
+ | ! Query/Update | ||
+ | | N/A || N/A || N/A || N/A | ||
+ | |- | ||
+ | ! Other Objects | ||
+ | | ? || ? || ? || ? | ||
+ | |} | ||
+ | |||
+ | ==== SwisSQL DB Change Manager ==== | ||
+ | [http://www.swissql.com/products/database-compare-synchronize-tool/ SwisSQL DB Change Manager] is an affordable and easy-to-use tool for Comparison and Synchronization of Microsoft SQL Server database schema. It also offers powerful Reporting, Auditing and a Web based client interface which makes it the best fit for collaborative database development and database change management. | ||
+ | [http://www.swissql.com/products/datamigration/data-migration.html?ad-main SwisSQL Data Migration Tool] helps the migration and transfer of database schemas and data across leading databases such as Oracle, IBM DB2, MS-SQL Server, Sybase, SAP DB, MySQL, PostgreSQL and MS Access. It offers an open, user-friendly, and extensible migration process ensuring reliability and data integrity. | ||
+ | |||
+ | {| border="1" | ||
+ | ! !! Document !! Predictability !! Transformation !! Reversibility | ||
+ | |- | ||
+ | ! Schema | ||
+ | | Version Control || Yes || Yes || Yes | ||
+ | |- | ||
+ | ! Data | ||
+ | | ?* || ?* || ?* || N/A | ||
+ | |- | ||
+ | ! Query/Update | ||
+ | | N/A || ?** || ?** || N/A | ||
+ | |- | ||
+ | ! Other Objects | ||
+ | | Probably || Yes*** || Yes*** || N/A | ||
+ | |} | ||
+ | [*] Yes, if Data Migration Tool supports schema evolution | ||
+ | [**] Yes, if [http://www.swissql.com/products/sqlone-apijava/sqlone-apijava.html SwisSQL SQL Query Migration Tools] support schema evolution. But probably not. | ||
+ | [***] SwisSQL Stored Procedure Migration Tools | ||
==== ==== | ==== ==== |
Revision as of 11:54, 23 October 2008
This page shows several Schema Evolution Systems. If you are looking for real schema evolving data, then click Benchmark Extension Datasets.
Schema Evolution Systems
Open Source
Liquibase
Liquibase is an open source (LGPL), DBMS-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes (structure and data) are stored in an XML-based descriptive manner and checked into source control.
Document | Predictability | Transformation | Reversibility | |
---|---|---|---|---|
Schema | DBDoc | Change log & Diff | Yes | lose-less operation |
Data | DBDoc | Change log & Diff | Yes | lose-less operation |
Query/Update | N/A | SQL Output | N/A | N/A |
Other Objects | DBDoc | Change log & Diff | Yes | lose-less operation |
Python Migration Packages[1]
Some packages support reversibility, but most of them are not.
Document | Predictability | Transformation | Reversibility | |
---|---|---|---|---|
Schema | Probably | N/A | Yes | few of Packages |
Data | Probably | N/A | Yes | few of Packages |
Query/Update | N/A | N/A | N/A | N/A |
Other Objects | N/A | N/A | Probably | N/A |
Ruby on Rails Migration Packages[2]
Document | Predictability | Transformation | Reversibility | |
---|---|---|---|---|
Schema | Probably | N/A | Yes | N/A |
Data | Probably | N/A | Yes | N/A |
Query/Update | N/A | N/A | N/A | N/A |
Other Objects | Probably | N/A | Probably | N/A |
Cake DB Migration[3]
Similar to Ruby on Rails Migration. It is coded by PHP.
Academic
Industrial
DB2® Change Management Expert
DB2 Change Management Expert is a powerful and flexible tool that simplifies the process of identifying, analyzing, and implementing database schema changes for DB2 UDB for Linux®, UNIX, and Windows®. DB2 Change Management Expert simplifies the process of managing schema changes. You can use DB2 Change Management Expert to visualize your changes before you make them. You can use DB2 Change Management Expert to apply change commands to physical data models, which enables you to see the results of the change commands before you deploy the changes against the actual DB2 database. Applying a change command to a model is similar to issuing a command against DB2.
Document | Predictability | Transformation | Reversibility | |
---|---|---|---|---|
Schema | Creates a historical base model | Displays related schema changes, delta DDL | Graphical | Reverse |
Data | ? | Aggregates summary | Yes | ? |
Query/Update | N/A | N/A | N/A | N/A |
Other Objects | ? | database dependencies | Probably Yes | ? |
Oracle Change Management Pack
Oracle Change Management Pack introduces integrated, Web-based tools for capturing and comparing metadata definitions. These tools provide a powerful system for tracking both metadata dictionary changes within a single database and differences between databases. Existing Oracle Change Management Pack components let users carry out schema upgrades and other complex database changes effortlessly, safely, and without loss of data.
Document | Predictability | Transformation | Reversibility | |
---|---|---|---|---|
Schema | Backing out | Yes | Graphical | Reverse |
Data | Probably Yes | Yes | Yes | Reverse |
Query/Update | N/A | Probably--Impact Report | N/A | N/A |
Other Objects | ? | Probably Yes | Yes | Reverse |
MySQL Workbench - Change Management
MySQL Workbench enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases. It includes everything a data modeler needs for creating complex ER models, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort. Database change management is a difficult and complex process, which involves maintaining different versions of database schemas and manually modifying existing databases. To help DBAs and developers with change management, MySQL Workbench includes Schema Synchronization and Comparison utilities. A DBA can compare two live databases or a model and a live database and visually see the differences, and also perform a synchronization between a model and a live database or vice versa.
Document | Predictability | Transformation | Reversibility | |
---|---|---|---|---|
Schema | DBDoc* | Yes | Graphical | Reverse |
Data | DBDoc* | Yes | Yes | Reverse |
Query/Update | N/A | N/A | N/A | N/A |
Other Objects | Probably DBDoc* | Yes | Yes | Reverse |
[*] DBDoc is available only on commercial version.
IDERA SQL Change Manager
IDERA SQL Change Manager is a powerful solution for simplifying and automating change management for Microsoft SQL Server databases. SQL change manager streamlines database change management procedures by capturing periodic database schema snapshots, highlighting changes from a baseline, and enabling easy roll-back, roll-out and recovery of lost or damaged database objects. Designed to meet the needs of enterprise-scale SQL Server implementations, SQL change manager easily scales to monitor and automate schema changes in environments of any size.
Document | Predictability | Transformation | Reversibility | |
---|---|---|---|---|
Schema | Version Control | Yes | Graphical | Rollback |
Data | Version Control | Yes | Yes | Rollback |
Query/Update | N/A | N/A | N/A | N/A |
Other Objects | Version Control | Yes | Yes | Rollback |
Embarcardero Change Manager
Embarcardero Change Manager offers database administrators and developers a powerful set of tools to simplify and automate the database change management lifecycle. Change Manager's schema compare and alter, data compare and synchronization, and configuration auditing capabilities report on database changes, roll out new releases, and pinpoint database performance problems that result from both planned and unplanned changes.
Document | Predictability | Transformation | Reversibility | |
---|---|---|---|---|
Schema | record of database schema | Yes | Yes | ? |
Data | ? | Probably Yes | Probably Yes | ? |
Query/Update | N/A | N/A | N/A | N/A |
Other Objects | ? | Probably Yes | Probably Yes | ? |
RedGate SQL Solutions (multiple solutions)
RedGate SQL Compare is the industry-standard tool for comparing and synchronizing SQL Server database schemas. It's used by over 150,000 developers, DBAs and test engineers worldwide because it's easy to use, it's fast, and it saves time. RedGate SQL Data Compare is used for automating data migrations, analyzing corrupted data, restoring row-level data from backups and compiling audit trails of missing or changed data. It's the industry standard tool for comparing and synchronizing the contents of two databases because it's very reliable and also very fast. RedGate SQL Dependency Tracker allows you to dynamically explore all your database object dependencies, using a range of graphical layouts. You can analyze large Microsoft SQL 2000, 2005 and 2008 databases and produce an easy-to-read dependency diagram for thorough pre-impact analysis of all database changes. SQL Refactor allows you to automatically format your SQL code and database objects in the style of your choice. SQL Refactor improves the quality of your code, making it easier to read, understand and share amongst a team. A companion tool to SQL Prompt, SQL Refactor dramatically speeds up database development and administration, without impacting on the behavior of your database and applications.
Document | Predictability | Transformation | Reversibility | |
---|---|---|---|---|
Schema | database versioning* | Yes* | Yes* | ? |
Data | database versioning** | Yes** | Yes** | ? |
Query/Update | N/A | N/A | N/A | N/A |
Other Objects | Yes*** | Yes*** | Yes**** | ? |
[*] SQL Compare [**] SQL Data Compare [***] SQL Dependency Tracker [****] SQL Refactor
Best SoftTool SQL DB Compare
SQL DB Compare is a robust database schema/data comparison and synchronization tool for SQL Server databases. It provides you great ease and productivity to manage SQL Server database development and production maintenance.
Document | Predictability | Transformation | Reversibility | |
---|---|---|---|---|
Schema | ? | Yes | Yes | ? |
Data | ? | Yes | Yes | ? |
Query/Update | ? | N/A | N/A | N/A |
Other Objects | ? | Yes | Yes | ? |
Toad® DBA Suite
Toad® DBA Suite is a bundle comprised of four tools that simplify common database administration tasks and help you become more proactive in solving database-related performance issues before they impact the production environment. As a database administrator (DBA), you have to be more versatile than ever before. That's because you are under constant pressure to implement application and database changes and quickly resolve problems, while preventing data loss or corruption. Plus, you must manage a variety of toolsets, while meeting service levels for performance and availability.
Document | Predictability | Transformation | Reversibility | |
---|---|---|---|---|
Schema | ? | ? | Yes | ? |
Data | ? | ? | ? | ? |
Query/Update | N/A | N/A | N/A | N/A |
Other Objects | ? | ? | Probably--Yes | ? |
Aldon Change Management Software
Aldon Lifecycle Management Solution brings process management, quality and predictability to database application development. Aldon's database change solution manages database and application code in a unified environment, greatly simplifying code development across multiple databases on multiple platforms. Database development can be easily integrated with application development using the Aldon database change and source management solution.
Altova Schema Agent
Altova SchemaAgent® 2008 is the visionary tool for analyzing and managing relationships among XML Schemas, XML instance documents, XSLT files,and WSDL files, as well as viewing files used in Altova MapForce data mapping projects – across a project, an intranet, or even an enterprise. It allows you to visualize and manage XML file relationships easily via its graphical design view, and create new relationships using drag-and-drop functionality to automatically configure imports, includes, and/or redefines (IIRs).
DTM Database Suite (multiple solutions)
Document | Predictability | Transformation | Reversibility | |
---|---|---|---|---|
Schema | ? | DTM Schema Comparer | DTM Migration Kit | ? |
Data | ? | DTM Migration Kit | DTM Migration Kit | ? |
Query/Update | N/A | N/A | N/A | N/A |
Other Objects | ? | ? | ? | ? |
SwisSQL DB Change Manager
SwisSQL DB Change Manager is an affordable and easy-to-use tool for Comparison and Synchronization of Microsoft SQL Server database schema. It also offers powerful Reporting, Auditing and a Web based client interface which makes it the best fit for collaborative database development and database change management. SwisSQL Data Migration Tool helps the migration and transfer of database schemas and data across leading databases such as Oracle, IBM DB2, MS-SQL Server, Sybase, SAP DB, MySQL, PostgreSQL and MS Access. It offers an open, user-friendly, and extensible migration process ensuring reliability and data integrity.
Document | Predictability | Transformation | Reversibility | |
---|---|---|---|---|
Schema | Version Control | Yes | Yes | Yes |
Data | ?* | ?* | ?* | N/A |
Query/Update | N/A | ?** | ?** | N/A |
Other Objects | Probably | Yes*** | Yes*** | N/A |
[*] Yes, if Data Migration Tool supports schema evolution [**] Yes, if SwisSQL SQL Query Migration Tools support schema evolution. But probably not. [***] SwisSQL Stored Procedure Migration Tools
Academic
Document | Predictability | Transformation | Reversibility | |
---|---|---|---|---|
Schema | ||||
Data | ||||
Query/Update | ||||
Other Objects |