Ispirer Website Ispirer Toolkit Overview Free Trial

Objects Selection

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

As the default the “Specify Objects” option is chosen in the combo-box on the page. If you check the “Expert Mode” box in the lower left corner, the “Specify Objects” drop-down list will be activated, where you can select the “Use Query” option.

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:

With the “Use Query” option you can specify the query either in the text-box, which could be opened with doubleclick by “Select statement” table cell or by pressing on button “Add query” for new statement. You also could save the statement 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. For MSSQL syntax like [Person].[Person] the alias name for target table will also 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. The alias name for target table could be saved in file and also pointed for migration.

Next Page: Conversion Options
Previous Page: Target Options

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