Step 5 - Specify Export File Options

In the Export directory box, enter the path to the folder where data files, SQL, import scripts and log files should be exported. You can click (...) to indicate this folder. The current directory is a default folder. If the directory does not exist, SQLWays creates \Ispirer\SQLWays 3.7\Project directory.

In the Report file name box, enter the name of the HTML report file for viewing the conversion results stored in the Export directory. Click the enabled after complete export View Report... button at the last step of the migration to view the report.

Log file stored in the Export directory allows to understand every aspect of the migration process. In the Log file name box, enter its name and define whether to continue processing when an error occurs. By default the Continue processing when an error occurs check box is selected, so SQLWays does not stop processing and tries to perform the next task. If the Run in trace mode check box is selected, detailed information is written to this log file. It is typically requested by the technical support staff and can help to solve database export and conversion problems.

By default the Divide data file into parts of check box is clear, so the text file with exported table is not divided into parts. In this case the log record contains (sqlways.log):

Output data file: C:\Program Files\Ispirer\SQLWays 3.7\Project\gsd_locker_assignment.txt

If the Divide data file into parts of check box is selected it is possible to define the largest possible file size for text files in the edit box (2G is specified by default). G, M, K postfix can be specified to define gigabytes, megabytes and kilobytes. When this limit is exceeded SQLWays divides the text file into parts. Each file contains a whole number of rows. SQLWays creates the files: table_name.txt, table_name2.txt, ... table_nameN.txt.
Note: The minimal part size must exceed the maximum row size (without LOB data) multiplied by the prefetch row count.

Data file was divided into 2 files of 1G:
Output data file: C:\Program Files\Ispirer\SQLWays 3.7\Project\gsd_locker_assignment.txt
Output data file: C:\Program Files\Ispirer\SQLWays 3.7\Project\gsd_locker_assignment2.txt

In the LOB objects options box:

In the LOB directory box, enter the path or click (...) to indicate in which folder the data of LOB objects (large objects such as CLOB and BLOB data types in Oracle, IBM DB2; TEXT and IMAGE data types in Microsoft SQL Server, Sybase; MEMO data types in Access and FoxPro) are exported. It is used only for migration to IBM DB2 or Oracle. For each LOB value, SQLWays creates one file in the LOB directory, specifying the file name in the ASCII file containing the table rows. The default value is the subdirectory of the export directory.

Select in the Write the LOB data inside the text file is the data of LOB columns (CLOB, BLOB, TEXT, IMAGE and MEMO) be written inside the text file. If target database is Microsoft SQL Server, Sybase, MySQL or Pervasive.SQL, the LOB data are written inside the text file even if this option is not specified. This allows the LOB data to be transferred into Microsoft SQL Server and Sybase using the BCP utility, into MySQL using LOAD DATA INFILE command and into Pervasive.SQL using the BUTIL utility. By default, if target database is Oracle, IBM DB2 or not specified, each LOB value is written into a separate file. This allows the LOB data to be transferred into Oracle using SQL Loader and IBM DB2 IMPORT/LOAD utilities.

By default the Create a LOB subdirectory for each table check box is selected, so SQLWays creates a subdirectory in the LOB directory for each table in order to organize LOB files in it and improve performance. The name of the subdirectory is a table name. The name of files is the table are the names with extension equals a number of LOB files which were created for this table before.

Ispirer SQLWays Database Migration Software

Step 5 - Specify Export File Options