Ispirer SQLWays Database Migration Software

/LOBIN - Write the LOB data inside the text file

Syntax: /LOBIN

This option specifies that the data of LOB columns (CLOB, BLOB, TEXT, IMAGE and MEMO) be written inside the text file.

By default, if /TARGET 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.

If /TARGET is Microsoft SQL Server, Sybase, MySQL or Pervasive.SQL, the LOB data are written inside the text file even if the /LOBIN 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.

             

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.