Home. 
.

transparent

transparent

transparent

Convert Database Structures Between Databases of Different Types

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

Download 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).

Database conversion by drag and drop in Altova DatabaseSpy
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.



Altova DatabaseSpy database structure change script

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



Altova DatabaseSpy drag and drop database structure conversion

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.

Altova DatabaseSpy drag and drop database structure conversion
Click to enlarge

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

Database conversion change script in Altova DatabaseSpy
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.



Altova DatabaseSpy drag and drop database structure conversion

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



Altova DatabaseSpy drag and drop database structure conversion

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!



transparent
Download
Pricelist
Buy
Video
Datasheet
Print
Mail
Digg
delicious
.

Redmond Roundup Champion
Redmond Magazine Roundup Champion

.

Altova DatabaseSpy was chosen "best overall in terms of features" in a Redmond Magazine comparison of database tools!

.
DatabaseSpy Available
in German
.

Altova DatabaseSpy is now available in English and German versions from our download page.

.
.

transparent

transparent