Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
sqlways:command-line:options [February 22, 2019, 12:25:13 PM] alexandr.kirpichnysqlways:command-line:options [May 31, 2023, 05:28:08 PM] (current) – external edit 127.0.0.1
Line 1: Line 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 ======
  
Line 9: Line 9:
 | /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. | |
Line 29: Line 29:
 | /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) |
Line 83: Line 83:
    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]] 

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