Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

Command-line Options

Syntax Description Example Default Value
/D Data source name (ODBC alias) /D=ODBC_conect
/U User name /U=sa
/P Password /P=pass
/O Convert all objects according to template by the rules (use it without /PRJF option): /O=*.* - select all objects from all schemas;
/O=dbo1.* - select all objects from certain schema;
/O=dbo1.tab1 - select objects with certain name from schema dbo1;
/O=*.tab1 - select objects with name tab1 from all schemas;
When selecting the list of objects need to use '|' as delimiter and enclose in quotes:
/O=“dbo1.tab1|dbo.tab2” - select list of objects;
/O=“dbo1.*|dbo2.tab1”,
/O=“*.tab1|dbo2.tab2”- the template should be always in the very beginning
Also take into account the case sensitivity of objects name in DBMS when specifying schema and/or object name.
In that situation the case-sensitive search will perform.
/T Table name, list of tables or table template according to the rules (use it without /PRJF option): /T=*.* - select all tables from all schemas;
/T=dbo1.* - select all tables from certain schema;
/T=dbo1.tab1 - select table tab1 from schema dbo1;
/T=*.tab1 - select table tab1 from all schemas;
When selecting the list of tables, need to use '|' as delimiter and enclose in quotes:
/T=“dbo1.tab1|dbo.tab2” - select list of tables;
/T=“dbo1.*|dbo2.tab1”,
/T=“*.tab1|dbo2.tab2”- the template should be always in the very beginning;
Also take into account the case sensitivity of objects name in DBMS when specifying schema and/or object name.
In that situation the case-sensitive search will perform.
/V View name, list or template according to the rules (use it without /PRJF option) /V=*.* - select all views from all schemas;
/V=dbo.* - select all views from schema dbo;
/V=dbo.v1 - select view v1 from schema dbo;
/V=*.v1 - select all view with name v1 from all schemas;
When selecting the list of views, need to use '|' as delimiter and enclose in quotes:
/V=“dbo.v1|dbo.v2 ” - select list of views;
/V= “dbo.*|dbo1.v1” - the template should be always in the very beginning;
Also take into account the case sensitivity of objects name in DBMS when specifying schema and/or object name.
In that situation the case-sensitive search will perform.
/SP Stored procedure name, list or template according to the rules (use it without /PRJF option) /SP=*.* - select all stored procedures from all schemas;
/SP=dbo.* - select all stored procedures from schema dbo;
/SP=dbo.sp1 - select stored procedure sp1 from schema dbo;
/SP=*.sp1 - select all stored procedures with name sp1 from all schemas;
When selecting the list of stored procedures, need to use '|' as delimiter and enclose in quotes:
/SP=“dbo.sp1|dbo.sp2 ” - select list of stored procedures;
/SP= “dbo.*|dbo1.sp1” - the template should be always in the very beginning;
Also take into account the case sensitivity of objects name in DBMS when specifying schema and/or object name.
In that situation the case-sensitive search will perform.
/FN Function name, list or template according to the rules (use it without /PRJF option) /FN=*.* - select all functions from all schemas;
/FN=dbo.* - select all functions from schema dbo;
/FN=dbo.fn1 - select function fn1 from schema dbo;
/FN=*.fn1 - select all functions with name fn1 from all schemas;
When selecting the list of functions, need to use '|' as delimiter and enclose in quotes:
/FN=“dbo.fn1|dbo.fn2 ” - select list of functions;
/FN= “dbo.*|dbo1.fn1” - the template should be always in the very beginning;
Also take into account the case sensitivity of objects name in DBMS when specifying schema and/or object name.
In that situation the case-sensitive search will perform.
/TG Trigger name, list or template according to the rules (use it without /PRJF option) /TG=*.* - select all triggers from all schemas;
/TG=dbo.* - select all triggers from schema dbo;
/TG=dbo.trg1 - select trigger trg1 from schema dbo;
/TG=*.trg1 - select all triggers with name trg1 from all schemas;
When selecting the list of triggers, need to use '|' as delimiter and enclose in quotes:
/TG=“dbo.trg1|dbo.trg2 ” - select list of triggers;
/TG= “dbo.*|dbo1.trg1” - the template should be always in the very beginning;
Also take into account the case sensitivity of objects name in DBMS when specifying schema and/or object name.
In that situation the case-sensitive search will perform.
/PKG Package name, list or template according to the rules (use it without /PRJF option) /PKG=*.* - select all packages from all schemas;
/PKG=dbo.* - select all packages from schema dbo;
/PKG=dbo.pkg1 - select package pkg1 from schema dbo;
/PKG=*.pkg1 - select all packages with name pkg1 from all schemas;
When selecting the list of packages, need to use '|' as delimiter and enclose in quotes:
/PKG=“dbo.pkg1|dbo.pkg2 ” - select list of packages;
/PKG= “dbo.*|dbo1.pkg1” - the template should be always in the very beginning;
Also take into account the case sensitivity of objects name in DBMS when specifying schema and/or object name.
In that situation the case-sensitive search will perform.
/UA User account, list or template according to the rules (use it without /PRJF option) /UA=*.* - select all user accounts from all schemas;
/UA=user1 - select user1 user account;
When selecting the list of user accounts, need to use '|' as delimiter and enclose in quotes:
/UA=“user1|user2|user3” - select list of user account;
Also take into account the case sensitivity of objects name in DBMS when specifying schema and/or object name.
In that situation the case-sensitive search will perform.
/SQ Sequence name, list or template according to the rules (use it without /PRJF option) /SQ=*.* - select all sequences from all schemas;
/SQ=dbo.* - select all sequences from schema dbo;
/SQ=dbo.sq1 - select sequence sq1 from schema dbo;
/SQ=*.sq1 - select all sequences with name sq1 from all schemas;
When selecting the list of sequences, need to use '|' as delimiter and enclose in quotes:
/SQ=“dbo.sq1|dbo.sq2 ” - select list of sequences;
/SQ= “dbo.*|dbo1.sq1” - the template should be always in the very beginning;
Also take into account the case sensitivity of objects name in DBMS when specifying schema and/or object name.
In that situation the case-sensitive search will perform.
/SN Synonym name, list or template according to the rules (use it without /PRJF option) /SN=*.* - select all synonyms from all schemas;
/SN=dbo.* - select all synonyms from schema dbo;
/SN=dbo.sn1 - select synonym sn1 from schema dbo;
/SN=*.sn1 - select all synonyms with name sn1 from all schemas;
When selecting the list of synonyms, need to use '|' as delimiter and enclose in quotes:
/SN=“dbo.sn1|dbo.sn2 ” - select list of synonyms;
/SN= “dbo.*|dbo1.sn1” - the template should be always in the very beginning;
Also take into account the case sensitivity of objects name in DBMS when specifying schema and/or object name.
In that situation the case-sensitive search will perform.
/EX Expression name, list or template /EX=*.*
/F Script files path, name, list or template /F=*.sql; /F=*.*; etc.
/FF Text file with the list of script files path, name, list or template /FF=file_list.txt
The contents of the file_list.txt Like:
S:\POC\file1.p
S:\POC\file2.p
S:\POC\file15.p
/S SELECT statement /S=SELECT * FROM Tab1
/SF File containing SELECT statement /SF=S:\Select_stmt_folder\select_file.sql
/SROW Start row /SROW=10 1
/CNROWS Number of rows to be exported /CNROWS=100 all rows
/SOURCE Type of source database/application: /SOURCE=Oracle
/TARGET Type of target database/application: /TARGET=DB2 the same as for the /SOURCE
Access - Access database
Advantage - Advantage database
ANSI - Ansi SQL
ANTS - ANTS database
ASPNET - ASP.NET
CPP - C++
C# - C#
DB2 / IBM DB2 - DB2 database
Excel - Excel
Foxpro - Foxpro database
Informix - Informix database
Informix 4GL - Informix 4GL
Informix 4GL form - Informix 4GL form
Ingres - Ingres database
Interbase - Interbase database
Java - Java
KSH - Korn Shell
Lotus - Lotus database
MSSQL / Microsoft SQL Server - Microsoft SQL Server database
MySQL - MySQL database
MySQL API - MySQL API
Neoview - Neoview database
Object Pal - Object Pal
Oracle - Oracle database
Oracle OCI - Oracle OCI
Paradox - Paradox database
Paradox FSL - Paradox FSL
Paradox RSL - Paradox RSL
Pascal - Pascal
Pascal FRM - Pascal FRM
PB - PowerBuilder
Perl - Perl
Pervasive - Pervasive.SQL database
PostgreSQL / Postgre - PostgreSQL database
Progress - Progress database
Progress 4GL - Progress 4GL
Python - Python
RDL - Report Definition Language
SAS - SAS
Solid - Solid database
Sybase API - Sybase API
SybaseASA - Sybase Adaptive Server Anywhere database
SybaseASE / Sybase Adaptive Server Enterprise / Adaptive Server Enterprise -
Sybase Adaptive Server Enterprise database
Teradata - Teradata database
VB - Visual Basic
VBNET - Visual Basic.NET
/SOURCE_DB Type of source database in application: /SOURCE_DB=Oracle
/TARGET_DB Type of target database in application: /TARGET_DB=Informix the same as for the /SOURCE_DB)
/SOURCE_API Type of source database API in application: /SOURCE_API=Oracle OCI
/TARGET_API Type of target database API in application: /TARGET_API=ODBC the same as for the /SOURCE_API
/TPROD Product of the target database:
DB2LUW - IBM DB2
DB2zOS - IBM DB2 for z/OS and OS/390
DB2iSeries - IBM DB2 for iSeries
SybaseASE - Sybase Adaptive Server Enterprise
SybaseASA - Sybase Adaptive Server Anywhere
/TPROD=DB2zOS none
/TVER Target database version /TVER=5.4
/TH Target host/server name /TH=CompName
/TD Target database name /TD=Tdatabase
/TU User name for the target database /TU=ora
/TP User password for the target database /TP=tpassword
/IMPORD Migration sequence:
Clean - Create constraints before importing data
Fast - Import data before creating constraints and indexes
Ready - Create constraints and indexes before importing data
/MIGS=Fast Clean
/IMPS Import system:
Windows - Microsoft Windows
Unix - Unix family
/IMPS=Unix Windows
/DIR Directory for export files /DIR=“C:\Some Import Dir\” current
/LOBDIR Directory for LOB files /LOBDIR=C:\Lobs_dir subdirectory LOBS of /DIR
/IMPDIR Directory where import will be executed /IMPDIR=S:\import\direct1 /DIR
/IMPLOB Import directory for LOBs /IMPLOB=S:\import\direct1\LOBS subdir LOBS of /IMPDIR
/OSN Output schema (owner) name /OSN=dbo1 the source schema
/OTN Output table name /OTN=new_tab_name name of the source table
/OFN Output files name /OFN=new_tab_name name of the output table
/OTF Output text file name (possibly with an extension) /OTF=new_table_name.txt
/DDL Generate DDL statements only /DDL
/OF Output format:
CSV - Column-delimited (CSV) output format
FIX - Fixed positions output format
TAB - TAB-delimited format
INS - SQL INSERT statements
XML - XML output format
BTR - Btrieve output format
/OF=CSV depends on /TARGET
/CDEL Column delimiter /CDEL=SWV_CDEL comma
/LDEL Line delimiter /LDEL=SWV_LDEL carriage return and new line symbols
/DECPT Decimal point character /DECPT=, period
/STDEL Statement termination string /STDEL=; semicolon
/LOBIN Write the LOB data inside the text file /LOBIN
/TABLST Generate list of tables available by using template /T only /TABLST
/R Rows prefetch count /R=2000 1000
/INI Initialization file /INI=S:\SQLWays\sqlways1.ini sqlways.ini
/PRJF Include Project file to migration process /PRJF=“C:\Program Files\Ispirer\SQLWays\sqlways.xml” sqlways.xml
/NSTOP Continue when an error occurs /NSTOP
/GCMD General command file name /GCMD=sqlways_all.bat depends on /IMPS
/NODDL Not generate DDL scripts /NODDL
/NOCMD Not generate OS command files /NOCMD
/RC Generate replication scripts /RC
/RPT Report file name /RPT=sqlways_report.html sqlways_report.html
/LOG Log file name /LOG=sqlways1.log sqlways.log
/TRACE Run in trace mode /TRACE
/REG Run for registration /REG
/UNREG Run for unregistration /UNREG
/HELP Show help information /HELP
/TEST Generates testing scripts for destination database /TEST
/STATS Collects statistics about DML objects along with conversion.
If it is defined as LOC then only statistics about DML objects are collected only
If it is defined as DETAIL then statistics about all statements are collected along with data export.
/STATS
/STATS=LOC
/STATS=DETAIL
/ASSESS Collects statistics about all statements without data export /ASSESS


/FF option usage Example:

 sqlways.exe /D=FIXED /SOURCE=Progress 4GL /TARGET=CS /FF=S:\Sqlways\Test\Auto\Progress 4GL\For Converter\CS\Ispirer\Option_FF_absolute\Objects.txt /INI=sqlways.ini /DIR=rslt
 The contents of the Objects.txt can be as follows:
 S:\Sqlways\Test\Auto\Progress 4GL\For Converter\CS\Ispirer\Option_FF_absolute\src\bo\AbcCode\AbcCode.p
 S:\Sqlways\Test\Auto\Progress 4GL\For Converter\CS\Ispirer\Option_FF_absolute\src\bo\zKey\zKey.p
 S:\Sqlways\Test\Auto\Progress 4GL\For Converter\CS\Ispirer\Option_FF_absolute\src\lib\GetLangDesc.i
 

/O option usage Example - select all objects from all schemas:

 sqlways.exe /IMPS=Windows /IMPORD=Clean /D=ORA /U=ora /P=ora /O=*.* /STDEL=GO /DIR=Export /LOG=sqlways.log /TARGET=Microsoft SQL Server /NSTOP /RPT=reports /GCMD=sqlways_all.bat /INI=sqlways_db.ini
    

/O option usage Example - select all objects from schema ORA:

 sqlways.exe /IMPS=Windows /IMPORD=Clean /D=ORA /U=ora /P=ora /O=ORA.* /STDEL=GO /DIR=Export /LOG=sqlways.log /TARGET=Microsoft SQL Server /NSTOP /RPT=reports /GCMD=sqlways_all.bat /INI=sqlways_db.ini
 

/T option usage Example - select all tables from schema ORA:

 sqlways.exe /IMPS=Windows /IMPORD=Clean /D=ORA /U=ora /P=ora /T=ORA.* /STDEL=GO /DIR=Export /LOG=sqlways.log /TARGET=Microsoft SQL Server /NSTOP /RPT=reports /GCMD=sqlways_all.bat /INI=sqlways_db.ini
 

/T option usage Example - select table TAB1 from schema ORA:

 sqlways.exe /IMPS=Windows /IMPORD=Clean /D=ORA /U=ora /P=ora /T=ORA.TAB1 /STDEL=GO /DIR=Export /LOG=sqlways.log /TARGET=Microsoft SQL Server /NSTOP /RPT=reports /GCMD=sqlways_all.bat /INI=sqlways_db.ini
 


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/command-line/options.txt · Last modified: December 01, 2021, 11:11:18 AM by pyatosina
 
© 1999-2022, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement