Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

Specify Import Options

Bin Directory

In this text-box you need to specify the path to the folder containing the native utilities that will be used to make an import into the target database. Usually path specification is not required as SQLWays automatically searches for the BIN directory. If the text-box is empty, first it searches the PATH variable, then it searches the registry. If it failed to find the path to the native utilities, no path is added to the import command and system may return the error during the import process.

Oracle

For Oracle you need to specify the path to the folder containing the sqlldr.exe tool.

Microsoft SQL Server

For Microsoft SQL Server you need to specify the path to the folder containing the bcp.exe and sqlcmd.exe native utilities.

MySQL

For MySQL database you need to specify the path to the folder containing the mysql.exe native utility.

PostgreSQL

For PostgreSQL database you need to specify the path to the folder containing the psql.exe native utility.

Teradata

For Teradata database you need to specify the path to the folder containing the bteq.exe native utility.

SAP HANA

For Sap Hana database you need to specify the path to the folder on local machine that contains the hdbsql.exe native utility.

Import Order For Tables

In the Import Order for tables, select the order of table constraints, importing data and indexes creating. Available values are:
Clean” (Create constraints before importing data);
Fast” (Import data before creating constraints and indexes, recommended for better performance in MySQL);
Ready” (Create constraints and indexes before importing data).


Depending on this option SQLWays creates different command files to import tables. Default value is Clean.

Advanced Options

Advanced button appears when only tables were selected for current migration process. And options in this window defines the types of the objects that will be loaded into the target database during the import:
Full” - Will do the import of all the converted objects (Table definitions, data, constraints, indexes).
DDL” - Option that defines whether the import of converted table definitions will be done.
Constraints” - Option that defines whether the import of converted constraints will be done.
DATA” - Option that defines whether the import of converted data will be done.
Indexes” - Option that defines whether the import of converted Indexes will be done.
Generated Objects” - Option that defines whether the import of additionally generated objects will be done. ( Objects that are generated by SQLWays Wizard automatically in order to emulate the logic of some features of the source database. Names of such objects starts with prefixes SWT_ or SWP_ or SWF_ ).

This feature allows to control the import process and define the required order of the import process as er your needs.


Please note!

This option doesn't influence on the conversion process. And Ispirer SQLWays Wizard will extract and convert all the objects (DDLs, Constraints, Indexes and additionally generated objects) and data. But during the import process only selected objects will be loaded.



If you will have some questions or face with some difficulties please contact our support team: support@ispirer.com


Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays

sqlways/users-guide/wizard/specify-import-opt.txt · Last modified: September 03, 2020, 03:44:09 PM by alexandr.kirpichny
 
© 1999-2020, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement