Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:migration-assessment:database:choose-source-db [July 10, 2018, 02:53:12 PM]
alexandr.kirpichny
sqlways:migration-assessment:database:choose-source-db [July 23, 2018, 12:11:35 PM] (current)
anastasiya.shpakava
Line 11: Line 11:
 ===== Select or Create an ODBC Data Source ===== ===== Select or Create an ODBC Data Source =====
  
-To start a database assessment process, first, tune-up an ODBC connection to the source database. It can be "User/System DSN" or "File DSN". After the ODBC connection is tuned-up and connection is checked, you can use it in SQLWays Migration Assessment Wizard to connect to your source database. +To start a database assessment process, first of all set up an ODBC connection to the source database. It can be "User/System DSN" or "File DSN". After the ODBC connection is tuned-up and connection is checked, you can use it in the SQLWays Migration Assessment Wizard to connect to your source database. 
  
 Then, fill in "User name" and "User password" fields. \\ It is strongly recommended to log in as a database user with administrative privileges since the assessment process involves access to system tables and views to collect additional information about the source database. Then, fill in "User name" and "User password" fields. \\ It is strongly recommended to log in as a database user with administrative privileges since the assessment process involves access to system tables and views to collect additional information about the source database.
Line 22: Line 22:
 === Logical File Path === === 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 collect information about 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.+This text-box allows you to specify the path to the folder containing the description of the logical files (DDS files). It is required if you need to collect information about Logical files from DB2 iSeries (AS400). Also, please, note that for each logical file there should exist a DDS file with description and with the same name as the Logical file. If the text-box is empty, the 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: Here you can find a step by step guide on how to extract the DDS files for logical files that should be converted:
Line 32: Line 32:
 __**Please note:**__ __**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.+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, the way you do it with other object types.
  
  
sqlways/migration-assessment/database/choose-source-db.1531234392.txt.gz · Last modified: July 10, 2018, 02:53:12 PM by alexandr.kirpichny
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement