Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

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:

Advanced Button

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)

Please note:

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.


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

sqlways/users-guide/wizard/choose-source-db.txt · Last modified: May 17, 2018, 02:08:48 PM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement