About Ispirer Systems
Ispirer Home Page Database Migration Application Conversion Downloads
Convert SQL Scripts in Batch Mode
Our tool 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 10 → Ispirer Toolkit 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: Ispirer Toolkit 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.