Both sides previous revisionPrevious revisionNext revision | Previous revision |
sqlways:command-line:options [February 22, 2019, 12:25:13 PM] – alexandr.kirpichny | sqlways:command-line:options [May 31, 2023, 05:28:08 PM] (current) – external edit 127.0.0.1 |
---|
\\ | \\ |
[[http://www.ispirer.com|Ispirer Home Page]] | [[https://www.ispirer.com|Ispirer Website]] |
[[http://www.ispirer.com/products|Ispirer SQLWays Product Page]] | [[https://www.ispirer.com/products/migration-toolkit|Ispirer Toolkit Overview]] |
[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]] | [[https://www.ispirer.com/download/download-demo|Free Trial]] |
====== Command-line Options ====== | ====== Command-line Options ====== |
| |
| /U | User name | /U=sa | | | | /U | User name | /U=sa | | |
| /P | Password | /P=pass | | | | /P | Password | /P=pass | | |
| /O | Convert all objects according to template | /O=*.* | | | | /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 | /T=dbo1.* | | | | /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 | /V=someschema.v* | | | | /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 | /V=any.sp_* | | | | /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 | /V=all.fn_* | | | | /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 | /V=trigger1 | | | | /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 | /V=pkg1 | | | | /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 | /UA=*.* | | | | /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 | /SQ=*.* | | | | /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 | /SN=*.* | | | | /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=*.* | | | | /EX | Expression name, list or template | /EX=*.* | | |
| /F | Script files path, name, list or template | /F=*.sql; /F=*.*; etc. | | | | /F | Script files path, name, list or template | /F=*.sql; /F=*.*; etc. | | |
| /SOURCE | Type of source database/application: | /SOURCE=Oracle | | | | /SOURCE | Type of source database/application: | /SOURCE=Oracle | | |
| /TARGET | Type of target database/application: | /TARGET=DB2 | the same as for the /SOURCE | | | /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 - 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 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 - PostgreSQL database \\ Progress - Progress database \\ Progress 4GL - Progress 4GL \\ Python - Python \\ RDL - Report Definition Language \\ SAS - SAS \\ Solid - Solid database \\ Sybase - Sybase database \\ Sybase API - Sybase API \\ SybaseASA - Sybase Adaptive Server Anywhere database \\ SybaseASE - Sybase Adaptive Server Enterprise database \\ Teradata - Teradata database \\ VB - Visual Basic \\ VBNET - Visual Basic.NET | | | | | | 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 | | | | /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) | | | /TARGET_DB | Type of target database in application: | /TARGET_DB=Informix | the same as for the /SOURCE_DB) | |
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\bo\zKey\zKey.p |
S:\Sqlways\Test\Auto\Progress 4GL\For Converter\CS\Ispirer\Option_FF_absolute\src\lib\GetLangDesc.i | 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 |
| |
| |
\\ | |
[[http://www.ispirer.com|Ispirer Home Page]] | |
[[http://www.ispirer.com/products|Ispirer SQLWays Product Page]] | |
[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]] | |