Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

Database Migration in Batch Mode

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

Open Command Line Window

Open a command line window by running Start → SQLWays 4.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 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.


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/command-line/database.txt · Last modified: March 20, 2013, 03:51:49 AM (external edit)
 
Ispirer Ispirer © 1999-2014, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement