Database Migration in Batch Mode

SQLWays allows you converting objects from a database in a command line or a shell script.

Open a command line window by running Start → SQLWays 4.x → SQLWays 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: SQLWays command line options are case insensitive and their order is insignificant.

• /d specifies the ODBC Data Source Name (DSN) to use for the connection 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). In this folder, sqlways.log (conversion log) is located.
• /TARGET specifies the target database type

The list of available database types:

• 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 convert. You can specify one object name, list or template (*.*, * i.e.)
• /TF specifies the location of file with the list of tables to convert.

SQLWays Product Page Free Evaluation