Last year I covered each of the items in the Altova MissionKit 2008. The new version, MissionKit 2009, has been released, and rather than going through each product, I am going to focus on some new technologies that have been introduced into the product line. The feature I will look at in this article is database comparison and merging.
When you are working with databases, there are many times when you need to locate changes, migrate differences, or synchronize versions of database data. It is here that DatabaseSpy 2009 and DiffDog 2009 come in. They, each in their own way, allow you to do comparison and merging across systems.
DatabaseSpy 2009 is a multi-database query, design, and database comparison tool that connects to all major databases. It makes management and care of your databases easier and provides the ability to visualize, design, compare the contents, and change the structures, even across different brands of databases.
Because DatabaseSpy 2009 is a multi-database tool, it is able to connect to all of the following major database types:
• Microsoft SQL Server 2000, 2005, 2008
• IBM DB2 8, 9
• IBM DB2 for iSeries v5.4
• Oracle 9i, 10g, 11g
• Sybase 12
• MySQL 4, 5
• PostgreSQL 8
• Microsoft Access 2003, 2007
The SQL editor features customizable auto-completion to accelerate query development. The graphical database design tool gives you the ability to visually modify tables and relationships without having to write SQL statements, and the ability to interact across multiple databases.
An area in which DatabaseSpy shines is its ability to let you compare and merge the contents of database tables via its graphical representation. This is especially handy when you are moving from one system to another. You are less likely to suffer downtime because something is missing.
DatabaseSpy 2009 can compare different versions of a table in the same database type, or compare and merge the contents of equivalent tables and entire database schemas from different database types. When you compare different database types, DatabaseSpy 2009 even resolves database type naming inconsistencies.
This means you can compare the customer table in your SQL Server database with a backup copy. Or if you are moving from Access to MS-SQL Server you can compare the contents of any table, or your entire database schema, in the two implementations. Automatic table mapping options let you map columns based on name, data type, or column position. You can set preferences for comparison options, XML-aware comparison for columns containing XML data, and display of the Results view.
Article comments