Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
sqlways:migration-assessment:database:choose-source-db [July 10, 2018, 02:53:12 PM] alexandr.kirpichnysqlways:migration-assessment:database:choose-source-db [May 31, 2023, 05:28:10 PM] (current) – external edit 127.0.0.1
Line 1: Line 1:
 \\ \\
-[[http://www.ispirer.com|Ispirer Home Page]] +[[https://www.ispirer.com|Ispirer Website]] 
-[[http://www.ispirer.com|Ispirer SQLWays Migration Product Page]] +[[https://www.ispirer.com/products/auxiliary-tools|Ispirer Assessment Tools Overview]] 
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]] +[[https://www.ispirer.com/download/download-demo|Free Trial]]
 ====== Choose a Source Database ====== ====== Choose a Source Database ======
  
Line 11: Line 10:
 ===== 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, firstly please 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 checked, you can use it in Ispirer Assessment Wizard to connect to your source database. 
  
-Thenfill 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 please 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 21:
 === 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). Please also note that for each logical file there should exist a DDS file with description and the same name as the Logical file. If the text-box is empty, the tool won'be able to convert DB2 logical files and a message "view body is not available (empty)" will appear in the sqlways.log file. 
 + 
 +After specifying an appropriate directory with DDS files, you will have to select the required logical files for assessment on the "Specify Database Objects" page like it is shown on the screenshot: 
 + 
 +{{:sqlways:migration-assessment:database:sel_lf_assessm.png?500|}} 
 + 
 + 
 +\\ 
 + 
 +===== ===== 
 + 
 +__**Please note:**__
  
 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 28: Line 38:
 __**[[http://wiki.ispirer.com/sqlways/specifics/ibm-db2/logical-files/extract-logical-files| How to Extract Logical and Physical Files From DB2 iSeries (AS400) ]]**__ __**[[http://wiki.ispirer.com/sqlways/specifics/ibm-db2/logical-files/extract-logical-files| How to Extract Logical and Physical Files From DB2 iSeries (AS400) ]]**__
  
 +\\ 
 +\\
  
 __**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.
  
 +\\
 +\\
 +If you have any additional questions regarding the assessment process, please contact our support team: __**[[[email protected]]]**__
  
 \\ \\
Line 40: Line 54:
 \\ \\
 \\ \\
-\\ +
-[[http://www.ispirer.com|Ispirer Home Page]] +
-[[http://www.ispirer.com|Ispirer SQLWays Migration Product Page]] +
-[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]+

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.