SQLWays allows you to convert application source files from command line or a shell script.

Open a command line window by running Start → Ispirer Toolkit → SQLWays Command Line or Start → Run → cmd.exe

To convert SQL scripts run sqlways.exe as follows:

sqlways.exe /f=d:\sybase_scripts\*.* /source=SybaseASE /target=MySQL /dir=d:\mysql_scripts

Note: SQLWays command line options are case insensitive and their order is insignificant.

• /F specifies the location of the source script files

You can specify a full path, list or template (*.*, *.sql i.e.)

• /SOURCE specifies the source database type
• /TARGET specifies the target database type

The list of available database types:

• Oracle - Oracle database
• DB2 - IBM DB2 database
• MSSQL - Microsoft SQL Server database
• Postgre - PostgreSQL database
• MySQL - MySQL database
• SybaseASE - Sybase Adaptive Server Enterprise (ASE) database
• SybaseASA - Sybase Adaptive Server Anywhere (ASA), Sybase SQL Anywhere database
• Informix - Informix database
• Progress - Progress database
• Teradata - Teradata database
• Neoview - HP Neoview database

• /DIR specifies the location of the converted script files (output directory). In this folder, sqlways.log (conversion log) is located.

SQLWays allows you to convert application source files from a command line or a shell script.

To convert applications run sqlways.exe as follows:

sqlways.exe /f=d:\delphi_project\*.* /source=Delphi /target=CS /dir=d:\CS_project

• /F specifies the location of the source script files

You can specify a full path, list or template (*.*, *.pas i.e.)

• /SOURCE specifies the source database
• /TARGET specifies the target database

The list of available applications:

• C# - C#.NET applications
• VB.Net - Visual Basic.NET applications
• Java - Java applications
• Delphi - Delphi applications
• CPP - C++ applications
• VB - Visual Basic applications
• Pascal - Pascal applications

• /DIR specifies the location of the converted script files (output directory). In this folder, sqlways.log (conversion log) is located.

To convert a Delphi project run sqlways.exe as follows:

sqlways.exe /F=c:\Delphi_project\Project.dpr /source=Delphi /target=CS /dir=d:\CS_project

Note: SQLWays command line options are case insensitive and their order is insignificant.

• /F specifies the location of the Delphi project file (.dpr)
• /SOURCE=Delphi specifies that the source application is Delphi
• /TARGET specifies the target application (C# in the example above)
• /DIR specifies the location of the converted script files (output directory). In this folder, sqlways.log (conversion log) is located.

To convert C++ applications with Embedded SQL to ODBC run sqlways.exe as follows:

sqlways.exe /F=s:\CPP_ESQL\*.* /SOURCE=CPP /TARGET=CPP /SOURCE_API=ESQLC /TARGET_API=ODBC /DIR=s:\CPP_ODBC

Note: SQLWays command line options are case insensitive and their order is insignificant.

• /F specifies the location of the source script files

You can specify a full path, list or template (*.*, *. cpp i.e.)

• /SOURCE=CPP specifies that the source application is C++
• /TARGET=CPP specifies that the target application is C++

• /SOURCE_API=ESQLC specifies the source API database type is Embedded SQL
• /TARGET_API=ODBC specifies the target API database type is ODBC

• /DIR specifies the location of the converted script files (output directory). In this folder, sqlways.log (conversion log) is located.

More detailed list of command line options can be found here: Command Line Options
If you will have any questions on how to run the migration in batch mode, please contact our technical team: support@ispirer.com