ProductsDatabaseSpyConvert Databases

Use the DatabaseSpy® 2010 Graphical Design Editor to convert an existing database to a new database type.

Migrating the structure of existing database tables from one database type to another, for instance from MySQL to SQL Server, can be a difficult and time-consuming effort due to differences in SQL dialects and datatype definitions between database vendors. DatabaseSpy® 2010 speeds this job with drag and drop database structure conversion functionality.

Databases Supported for DB Conversion

Details of the SQL database query language vary among implementations of relational database systems from different vendors. DatabaseSpy® 2010 supports multiple database types and automatically adapts its database structure conversion functionality to the following databases:

• 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

 Click here to download a fully functional, free 30-day trial of Altova® DatabaseSpy® 2010!

Convert Database Structures

You can can open multiple DatabaseSpy® 2010 Design Editor windows for different database types and simply drag existing tables from one database design to the other. In the example below, a table has been copied from MySQL to SQL Server (each database type is identified in the information bar at the bottom of the Design Editor window).

	Click to enlarge

Dragging the table to a new database instructs DatabaseSpy® 2010 to create a database structure change script that contains SQL statements to create the table in the new database SQL dialect.

The database structure change script offers several options. You can:

• Execute the script immediately
• Send the change script to a new SQL Editor window for enhancement or revision
• Save the change script in a file for archival backup or even to execute on a different server

Convert Database Structures from the Online Browser

You can also drag one or more tables directly from the Online Browser to convert them. First, open a Design Editor window for the target database, then simply select one or more tables in the source database and drag them over to the design.

	Click to enlarge

The Database Structure Change Script is created immediately and contains SQL statements to create all three tables.

	Click to enlarge

You can save the new tables in a Design Editor file and even add them to your project for further enhancement at a later time.

For instance, you can visually add foreign keys to define relationships between tables.

DatabaseSpy® 2010 will create the database change script automatically, eliminating the need to handwrite SQL statements.

See for yourself how easy it is to convert existing tables to a new database type with DatabaseSpy® 2010. Download a free 30-day trial today!