Ispirer Website Ispirer Toolkit Overview Free Trial

Convert Scripts in Batch Mode

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

Open Command Line Window

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

Convert SQL Scripts

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.

Convert Applications in Batch Mode

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

Convert Applications

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.

Convert Delphi Projects

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.

Convert C++ Applications with Embedded SQL to ODBC

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



© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.