Skip to content

How to not export data in Ispirer SQLWays

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:

SQLWays Wizard starting ...

Now enter the database connection details:

Source database connection details

Destination 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:

Database objects to migrate

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:

Specify options

Specify table options

The "Tables" options have a special tab which is not found in the other objects: "Data Options", click on this:

Data Options

You see the "Export data" checkbox, which - unfortunately - is enabled by default. Uncheck the box.

Uncheck the "Export data" checkbox

Now continue with the Wizard until you come to the summary screen:

Export File Options

Import options (if applicable)

And finally, start the migration:

Summary screen, start the migration

Very easy and the tool generates usable code from and to several supported databases.


No Trackbacks


Display comments as Linear | Threaded

No comments

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.
To leave a comment you must approve it via e-mail, which will be sent to your address after submission.
Form options