CL2SQL: Command Line Tool for Unattended Migration

Mertech provides a command line tool to allow migration of data using Flex2SQL features without the GUI interface. The tool, called cl2SQL, is located in the Mertechbin directory and supports all the options of Flex2SQL through command line parameters.

A good use of this tool would be to convert an existing DataFlex databases to SQL without any attendants. Cl2SQL can be used along with the CONVER_DAT (see Write Your Own Migration Routines Using the CONVERT_DAT_FILE Macro) command to develop unattended migration process.

To see all the options supported by CL2SQL, click on cl2SQL to run it and an information window will be displayed with all the options. These options are listed below:

 -?,-h,-help : This information screen. 

-d <drv>, : Use driver <drv> where drv is one of our supported drivers.
-driver <drv> Such as ORA_DRV, MDS_DB2, SQL_DRV, MDSMYSQL and MDSPGSQL.

-f <fs>, : The fileset passed as a parameter in <fs> on which you
-fileset <fs> want to operate.

-file <n> : The filenumber passed as a parameter in <n> on which you
want to operate. You can only use this option with a fileset
This allows you to override the set of files on which you
want to operate with another file.

-prefix <ABC>, : The prefix <ABC> and postfix <ABC> options are to be used
-postfix <ABC>, for the tablename prefix or postfix as an override on what is
defined in the fileset.

You can only use this option along with a fileset.

-s <server>, : Database <server> to connect to, where <server> can be either
-server <server> the server name or IP used.

-database <db> : If you want to use another database as is specified in the
configuration file, then you can override the setting with
the value in <db>.

-u <user>, : User id to login with.
-user <user> You should not set this when you want to login using
a trusted connection.

-p <pass>, : Password to use for logging in.
-password <pass>

-port <n> : Use an alternative port to connect to on the database server.

-c <cfg>,-config <cfg>: Use the provided configuration in <cfg> file

-l,-login : Automatically log in using the last used/saved parameters.
This is the default behaviour if no login details are passed.

-r <rpt>,-report <rpt>: Write a migration report to file <rpt>. 

-rc,-rptclear : Erase migration report file <rpt> (from the -report option).
 before the actual report is being written hereby opening the
 ability to not append to an existing report and start fresh.