Database Migration in Batch Mode

Our tool allows you to convert objects of a database in Command Line or in shell script.

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

To convert database objects run sqlways.exe as follows:

sqlways.exe /d=DSN_FOR_ODBC_CONNECTION /U=user_name /P=password /DIR=S:\Export_dir /target=Neoview /T=*.*

or
sqlways.exe /d=DSN_FOR_ODBC_CONNECTION /U=user_name /P=password /DIR=S:\Export_dir /target=Neoview /TF=S:\File_name.txt

Note: Ispirer Toolkit Command Line options are case insensitive and their order is insignificant.

• /d specifies the ODBC Data Source Name (DSN) to connect to the source database
• /U specifies the user name for the connection
• /P specifies the password for the connection
• /DIR specifies the location of the converted objects files (output directory). sqlways.log (conversion log) is located in this folder.
• /TARGET specifies the target database

The list of available databases:

• Access - Access database
• Advantage - Advantage database
• 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
• ANTS - ANTS database
• DB2 - DB2 database
• Excel - Excel
• Foxpro - Foxpro database
• Informix - Informix database
• Ingres - Ingres database
• Interbase - Interbase database
• Lotus - Lotus database
• MSSQL - Microsoft SQL Server database
• MySQL - MySQL database
• Neoview - Neoview database
• Oracle - Oracle database
• Paradox - Paradox database
• Pervasive - Pervasive.SQL database
• PostgreSQL - PostgreSQL database
• Progress - Progress database
• Solid - Solid database
• Sybase - Sybase database
• SybaseASA - Sybase Adaptive Server Anywhere database
• SybaseASE - Sybase Adaptive Server Enterprise database
• Teradata - Teradata database

• /T specifies the list of tables to be converted. You can specify one object name, a list or a template (*.*, * i.e.)
• /TF specifies the location of the file with the list of tables to be converted.

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