Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

Converting Scripts in Batch Mode

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

Open Command Line Window

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

Converting 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.

Converting Applications in Batch Mode

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

Converting 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 type
  • /TARGET specifies the target database type

The list of available application types:

  • 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.

Converting 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 type (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.

Converting 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.


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/command-line/scripts.txt · Last modified: March 20, 2013, 03:51:51 AM (external edit)
 
Ispirer Ispirer © 1999-2014, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement