Ispirer Website Ispirer Toolkit Overview Free Trial

Specify Database Objects or Query Page

This Wizard page lets you specify the list of objects to convert.

Specify Objects

As the default the “Specify Objects” option is chosen in the combo-box on the page.

You can chose any or all the objects on the left for the conversion.

Refresh Object List

If during the migration process the list of objects was updated, for example some additional objects were created or dropped from the database, you can refresh the list of extracted objects. To do that just right click on the required object type or on the “Database” branch and click “Refresh” button, like it is shown on the screenshot:

Use Query

With the “Use Query” option you can specify the query either in the text-box or in the file that will be used for DDL and data migration.

  • Specify a SQL Query Statement

You can specify the SQL statement of any complexity in this option that conforms to the source database syntax rules. As the result the DDL for the result table is created with the columns and the appropriate datatypes specified. The data returned by the query is stored in this table.

The columns of the result table are named like specified in the query, or the alias name is taken if it is specified in the query. If only one table is specified in the FROM clause then this table name will be used to name the result table. If there are two or more tables specified the result table name will be unknown.

  • Specify a File Containing a SQL Query Statement

The SQL statement may be stored in the separate file and used the same way as in the “Specify a SQL Query Statement” option.

Related Topics

Next Page: Specify DDL and Data Options Page
Previous Page: Choose Target Database Page
Official User's Guide: Ispirer Toolkit Official Guide

If you have any questions or face any difficulties, please contact our support team:

© 1999-2023, Ispirer Systems, LLC. All Rights Reserved.