Table of Contents
Ispirer Website Ispirer Toolkit Overview Free Trial
Choose a Source Database Page
Then we need to choose the ODBC connection to the source database that should be migrated. And specify a user and a password that will be used to connect to the source database.
How to Tune ODBC Connection
Our tool works using the ODBC connection to the source database only! It means that before using the SQLWays Wizard tool you need to install the ODBC driver and tune the ODBC connection to the database that should be migrated. Here you can find step by step guides on how to tune the ODBC connection for a specific database:
IBM DB2 for iSeries (AS400)
Logical File Path
This text-box lets you specify the path to the folder containing the description of the logical files (DDS files). It is required if you need to migrate Logical files from DB2 iSeries (AS400). Also, please, note that for each logical file there should exist a DDS file with the description with the same name as the Logical file. If the text-box is empty, SQLWays will not be able to convert DB2 logical files and will throw a message “view body is not available (empty)” in the sqlways.log file.
Here you can find a step by step guide on how to extract the DDS files for logical files that should be converted:
How to Extract Logical and Physical Files From DB2 iSeries (AS400)
If you are using DB2 iSeries 7.2 version or higher, you don't need to extract the DDS files and provide a path to them. You just need to specify logical files for conversion on the “Specify Database Objects” page, like you do it with other object types.
Oracle System View
Oracle System View option defines the Oracle view that SQLWays Wizard will make selects from, in order to get all the required information about the objects.
DBA - means that DBA_SOURCE system view will be used to select from. ALL - means that ALL_SOURCE system view will be used to select from.
Next Page: Target Database Page
Previous Page: Welcome Page
Official User's Guide: Ispirer Toolkit Official Guide
If you have any questions or face any difficulties, please contact our support team: email@example.com