Ispirer Website Ispirer Toolkit Overview Free Trial

Database Migration in Batch Mode

SQLWays allows you to convert objects of a database in command line or in shell script.

Open Command Line Window

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

Converting Tables

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



More detailed list of command line options can be found here: Command Line Options
If you will have any questions on how to run the migration in batch mode, please contact our technical team: support@ispirer.com


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.