Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
sqlways:users-guide:wizard:specify-import-opt [June 09, 2020, 02:42:52 PM] – alexandr.kirpichny | sqlways:users-guide:wizard:specify-import-opt [April 17, 2023, 01:51:05 PM] (current) – removed alexandr.kirpichny | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | \\ | ||
- | [[http:// | ||
- | [[http:// | ||
- | [[http:// | ||
- | ====== 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 // | ||
- | |||
- | ==== Microsoft SQL Server ==== | ||
- | |||
- | For Microsoft SQL Server you need to specify the path to the folder containing the //bcp.exe// and // | ||
- | |||
- | ==== MySQL ==== | ||
- | |||
- | For MySQL database you need to specify the path to the folder containing the // | ||
- | |||
- | ==== PostgreSQL ==== | ||
- | |||
- | For PostgreSQL database you need to specify the path to the folder containing the // | ||
- | |||
- | ==== Teradata ==== | ||
- | |||
- | For Teradata database you need to specify the path to the folder containing the // | ||
- | |||
- | ==== SAP HANA ==== | ||
- | |||
- | For Sap Hana database you need to specify the path to the folder on local machine that contains the // | ||
- | |||
- | |||
- | ===== Import Order For Tables ===== | ||
- | |||
- | In the Import Order for tables, select the order of table constraints, | ||
- | creating constraints and indexes, recommended for better performance in MySQL); | ||
- | |||
- | \\ 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. | ||
- | |||
- | 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' | ||
- | |||
- | |||
- | |||
- | |||
- | |||
- | \\ | ||
- | \\ | ||
- | If you will have some questions or face with some difficulties please contact our support team: [[[email protected]]] | ||
- | |||
- | \\ | ||
- | [[http:// | ||
- | [[http:// | ||
- | [[http:// |