Ispirer SQLWays Database Migration Software

Step 6 - Specify Import Options

On this page you specify options for the import stage.

SQLWays allows you to perform export and import on different systems and platforms.

If the Import is executed on the local system (remote target database) is clicked, select the Start import automatically check box to start import automatically.
If the Import is executed on a remote system (using this option SQLWays can properly
generate import scripts that contain file references) is clicked, you need to specify the operation system (Microsoft Windows or Unix system) where import to the target database will be executed. This option also defines rules for the path and new line delimiters that are used in the scripts and files generated by SQLWays.
If Windows is selected in the System box, SQLWays generates command files for importing using the Windows command interpreter. Windows uses a backslash symbol as the directory delimiter (d:\temp\dir\subdir1). In Windows a new line is defined by carriage return and new line characters (0x0D0A or \r\n).The default system is Windows.
If Unix is selected in the System box, SQLWays generates Bourne shell scripts. You can also use these scripts with the Korn shell, because it is upward compatible with the Bourne shell. Unix uses a slash symbol (tmp/dir1/subdir1). In Unix a new line is represented by new line character only (0x0A or \n).
By default, SQLWays specifies that shell scripts are executed by /bin/sh. Using this option you can specify another shell location, /usr/bin/sh e.g. This option is disabled if import is not executed on a Unix system.
In the Directory box, enter the path to the folder from which import is executed or click (...) to gain access to Browse for folder dialog box to indicate this folder. If you execute import on a Unix system, you can specify Unix paths in this option, like /usr/reports/data/.
In the LOB directory box, enter the path to the folder where the data of LOB objects (large objects) are located at the import stage or click (...) to indicate this folder. It is used only for migration to IBM DB2 or Oracle and only in cases when you transfer export files to another location before import and LOB files are not located in the subdirectory LOBS of /IMPDIR. Using this option SQLWays can properly generate import scripts that contain file references. The default value is the subdirectory of the import directory.
In the Migration sequence for tables, select the order of table constraints, importing data and creating indexes creating. Available values are Clean (Create constraints before importing data); Fast (Import data before creating constraints and indexes); Ready (Create constraints and indexes before importing data). Depending on this option SQLWays creates different command files to import tables. Default value is Clean.

             

Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.