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