Table of Contents
Ispirer Website
Ispirer Toolkit Overview
Free Trial
Specify Database Objects or Query Page
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: support@ispirer.com