Ispirer Website
Ispirer Toolkit Overview
Free Trial
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