Convert Scripts in Batch Mode

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

Open a command line window by running Start → SQLWays 8.x → 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, a list or a 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). sqlways.log (conversion log) is located in this directory.

Convert Applications in Batch Mode

Our tool 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, a list or a 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). sqlways.log (conversion log) is located in this folder.

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). sqlways.log (conversion log) is located in this folder.

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, a list or a 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 that the source API database type is Embedded SQL
  • /TARGET_API=ODBC specifies that the target API database type is ODBC
  • /DIR specifies the location of the converted script files (output directory). sqlways.log (conversion log) is located in this folder.



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



More about Ispirer Systems