Ispirer SQLWays is a nice (although commercial) tool to convert DDL and data from one supported database to another. We are using it regularly, the list of supported databases is impressive: PostgreSQL, Greenplum, Oracle, SQL Server, IBM DB2, MySQL, Sybase, Informix, Teradata, *Netezza *and some more.
There’s just one thing which I always forget: SQLways exports all data by default, which makes the export unnecessary big and slow.
Fortunately there’s an option to disable the data export, it’s hidden in the Wizard. From the beginning:
Start the SQLWays wizard:
Now enter the database connection details:
In this case I decide not to use a destination database connection, but instead just let SQLWays generate the necessary SQL code during the export.
Next step: select the database objects which should be migrated:
And in the next step it is possible to specify specific options to the different objects. I’m especially interested in the options for the tables:
The “Tables” options have a special tab which is not found in the other objects: “Data Options”, click on this:
You see the “Export data” checkbox, which - unfortunately - is enabled by default. Uncheck the box.
Now continue with the Wizard until you come to the summary screen:
And finally, start the migration:
Very easy and the tool generates usable code from and to several supported databases.