Both sides previous revisionPrevious revisionNext revision | Previous revision |
sqlways [May 17, 2018, 02:10:13 PM] – [Frequently Asked Questions] alexandr.kirpichny | sqlways [September 07, 2023, 09:25:14 AM] (current) – volha |
---|
\\ | \\ |
[[http://www.ispirer.com|Ispirer Website]] | [[https://www.ispirer.com|Ispirer Website]] |
[[http://www.ispirer.com/products|Ispirer SQLWays Migration 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]] |
| |
====== Ispirer Migration Knowledge Base ====== | ====== Ispirer Migration Knowledge Base ====== |
| |
===== Ispirer Migration and Modernization Assessment Toolkit (MnMATK) User's Guide ===== | ===== Ispirer Software Userguides ===== |
| |
* **[[sqlways:migration-assessment/database|Assessment Wizard for Databases]]** | * **[[https://support.ispirer.com/guides/migration-toolkit|Ispirer Toolkit User Guide]]** |
* **[[sqlways:migration-assessment/scripts|Migration Assessment Studio for Scripts]]** | * **[[https://support.ispirer.com/guides/migration-assessment|Ispirer Assessment Toolkit User Guide]]** |
| // |
| // |
| * **SQLWays Wizard** Page by Page Guide |
| * [[sqlways:users-guide/wizard/welcome|Welcome Page]] |
| * [[sqlways:users-guide/wizard/choose-source-db|Choose a Source Database Page]] |
| * [[sqlways:users-guide/wizard/choose-target-db|Choose a Target Database Page]] |
| * [[sqlways:users-guide/wizard/specify-db-objects-or-query|Specify Database Objects or Query Page]] |
| * [[sqlways:users-guide/wizard/specify-ddl-data|Specify DDL and Data Options Page]] |
| * [[sqlways:users-guide/wizard/summary|Summary Page]] |
| * [[sqlways:users-guide/export-results|Conversion Results]]\\ |
| |
**__[[sqlways:how-to-use-migration-assessment-wizard|How to Use Assessment Wizard for Databases]]__** | ===== Troubleshooting Guide ===== |
===== Ispirer Migration and Modernization ToolKit (MnMTK) User's Guide ===== | |
| |
* **[[sqlways:users-guide/toolkit-overview|Description]]** | * **[[sqlways:troubleshooting-guide/oracle|Oracle]]** |
* **[[sqlways:users-guide/installation-requirements|Installation Requirements]]** | * [[sqlways:troubleshooting-guide/oracle/export|Export]] |
| * [[sqlways:troubleshooting-guide/oracle/import|Import]] |
| * **[[sqlways:troubleshooting-guide/sql-server|Microsoft SQL Server]]** |
| * [[sqlways:troubleshooting-guide/sql-server/export|Export]] |
| * [[sqlways:troubleshooting-guide/sql-server/import|Import]] |
| * **[[sqlways:troubleshooting-guide/db2|IBM DB2]]** |
| * [[sqlways:troubleshooting-guide/db2/export-conversion|Export and Conversion]] |
| * [[sqlways:troubleshooting-guide/db2/import-conversion|Import & Conversion]] |
| * **[[sqlways:troubleshooting-guide/MySQL|MySQL]]** |
| * [[sqlways:troubleshooting-guide/mysql/import| Import]] |
| * **[[sqlways:troubleshooting-guide/postgresql|PostgreSQL]]** |
| * [[sqlways:troubleshooting-guide/postgresql/export-conversion|Export and Conversion]] |
| * [[sqlways:troubleshooting-guide/postgresql/import|Import]] |
| * **[[sqlways:troubleshooting-guide/Progress|Progress]]** |
| * [[sqlways:troubleshooting-guide/progress/export-conversion|Export and Conversion]] |
| * **[[sqlways:troubleshooting-guide/Informix|Informix]]** |
| * [[sqlways:troubleshooting-guide/informix/export-conversion|Export and Conversion]] |
| * **[[sqlways:troubleshooting-guide/sap-hana|SAP Hana]]** |
| * [[sqlways:troubleshooting-guide/sap-hana/import|Import]] |
| * **[[sqlways:troubleshooting-guide/sybase-ase|Sybase Adaptive Server Enterprise]]** |
| * [[sqlways:troubleshooting-guide/sybase-ase/export|Export]] |
| * [[sqlways:troubleshooting-guide/sybase-ase/import|Import]] |
| |
* **[[sqlways:users-guide/wizard|SQLWays Wizard]]**\\ | ===== Frequently Asked Questions ===== |
* [[sqlways:users-guide/wizard/choose-source-db|Source Database Page]] | |
* [[sqlways:users-guide/wizard/choose-target-db|Target Database Page]] | |
* [[sqlways:users-guide/wizard/specify-db-objects-or-query|Specify Objects Page]] | |
* [[sqlways:users-guide/wizard/specify-ddl-data|DDL and Data Options Page]] | |
* [[sqlways:users-guide/wizard/specify-export-file-opt|Export Options Page]] | |
* [[sqlways:users-guide/wizard/specify-import-opt|Import Options Page]] | |
* [[sqlways:users-guide/export-results|Conversion Results]]\\ | |
| |
| === Ispirer Assessment Toolkit === |
| |
* **[[sqlways:users-guide/studio|SQLWays Studio]]** | * [[sqlways:faq/light-installer-assessment-wizard|What to do if light installer fails to download the Ispirer MnMTAK toolkit]] |
* [[sqlways:users-guide/studio/choose-source-target|Choosing Source and Target]] | * [[sqlways:faq/how-to-run-as-administrator|How to Run the Tools as Administrator]] |
* [[sqlways:users-guide/studio/options-menu|Options Menu]]\\ | * [[sqlways:faq/how-to-assess-logical-files|How To Collect Information about Logical Files]] |
| |
* **[[sqlways:command-line|SQLWays Command Line]]** | === Ispirer Toolkit === |
* [[sqlways:command-line/database|Database Migration in Batch Mode]] | |
* [[sqlways:command-line/scripts|Converting Scripts in Batch Mode]] | |
* [[sqlways:command-line/options|Command-line Options]] | |
* [[sqlways:command-line/sqlways-ini|sqlways.ini file]] | |
* [[sqlways:command-line/sqlways-xml|sqlways.xml file]] | |
| |
\\ | * [[sqlways:faq/light-installer|What to do if light installer fails to download the Ispirer MnMTK toolkit]] |
**__[[sqlways:faq/how-to-use-sqlways-wizard|How to Use the Ispirer SQLWays Wizard tool]]__** | * [[sqlways:faq/how-to-register|How to Register the Ispirer MnMTK toolkit]] |
\\ | * [[sqlways:faq/how-to-run-as-administrator|How to Run the Tools as Administrator]] |
| * [[sqlways:faq/expert-mode|How to use the SQLWays Wizard in "Expert mode"]] |
| * [[sqlways:faq/how-to-use-sqlways-wizard|How to Use the Ispirer SQLWays Wizard tool]] |
| * [[sqlways:faq/trace-mode|How to Run the Conversion in Trace Mode]] |
| * [[sqlways:faq/set-options-sqlways-wizard|How to set up options in SQLWays Wizard tool]] |
| * [[sqlways:faq/how-to-work-with-parsers|How to Work With Parser Errors]] |
| * [[sqlways:faq/how-to-run-query-sqlways-wizard|How to run query in SQLWays Wizard]] |
| * [[sqlways:faq/how-to-run-in-parallel-mode|How to Run the SQLWays Wizard in Parallel Mode]] |
| * [[sqlways:faq/data-cut-extraction|How to Extract Piece of Data Using Conditions]] |
| * [[sqlways:faq/migrate-to-existing-database|How to Migrate Data into Existing Database]] |
| * [[sqlways:faq/manage-errors|How does SQLWays manage errors?]] |
| * [[sqlways:faq/work-unix-systems|Whether SQLWays can work under Unix like systems]] |
| * [[sqlways:faq/optimize-migration-process-large-tables|How to Optimize the Migration Process for Large tables]] |
| * [[sqlways:faq/optimize-migration-of-schema-and-data|How to Optimize the Migration of Schema and Data]] |
| * [[sqlways:faq/load-parameterization|Parameterize login information after import script generation]] |
| * [[sqlways:faq/change-decimal-point|How to Change a Decimal Point Character?]] |
| * [[sqlways:faq/export-file-formats|What Export File Formats are Supported by SQLWays?]] |
| * [[sqlways:faq/column-name-mapping|How to Change Column Name Mapping in SQLWays Wizard]] |
| * [[sqlways:faq/fk-convert|How to ensure that Foreign key is converted successfully from MySQL to SQL Server?]] |
| * [[sqlways:faq/recycle-bin|Why Does a Bunch of Invalid Objects with Garbage Names Appear in Oracle]] |
| * [[sqlways:faq/generate-ddl-without-data-export|How to Generate DDL Script without Data Export]] |
| * [[sqlways:faq/schedule-migration-process|How to Schedule the Migration Process]] |
| * [[sqlways:faq/dll-missing-from-your-computer| DLL Is Missing From Your Computer. How to solve it?]] |
| * [[sqlways:specifics/saphana/ddl-and-data| How To Make Import Into SAP Hana Database]] |
| * [[sqlways:faq/convert-database-objects-to-java|Convert SQL Database Objects to Java in SQLWays Wizard]] |
| * [[sqlways:faq/split-table|How To Split Table Into Several Small Tables]] |
| * [[sqlways:users-guide/test-features|How To Test Converted SQL Code]] |
| * [[sqlways:users-guide/export-import-command-line-mode|How To Convert and Import In Command Line Mode]] |
| * [[sqlways:users-guide/setting-up-database-connection/db2/what-driver-to-use|What DB2 AS400 Client To Use For ODBC Connection Tuning]] |
| * [[sqlways:faq/utilities-to-make-import|How to Find Bin Directory and Utilities To Make Import]] |
| * [[sqlways:faq/change_names_mapping|How to change objects names during the migration]] |
| * [[sqlways:faq/Postgresql-ssl-connection|How To Connect To PostgreSQL Database Using SSL Connection]] |
| * [[sqlways:faq/Generate-projects-files-cs|How to Generate C# Project Files During the Migration]] |
| * [[sqlways:faq/How-to-collect-debug-information|How to collect debug information about migration process]] |
| * [[sqlways:faq/how-to-use-query-with-scn|How to use queries with SCN in SQLWays Wizard]]\\ |
| |
===== Ispirer SQLWays Comparator User's Guide ===== | |
| |
* **[[sqlways:users-guide/db-compare|SQLWays Database Comparison Tool]]** | === Databases === |
* [[sqlways:users-guide/db-compare/command-line|Database Comparison in Batch Mode]] | |
* [[sqlways:users-guide/db-compare/wizard|Database Comparison Wizard]] | |
* [[sqlways:users-guide/db-compare/supported-options|Supported Options per Database]] | |
| |
| * [[sqlways:users-guide/generate-df-file|How to Generate .df File From Progress Database]] |
| * [[sqlways:users-guide/load-df-d-files-progress|How to Load Definitions (.df file) and Data (.d file) to Progress Database]] |
| |
===== Ispirer SQLWays Replicator Wizard User's Guide ===== | |
| |
* **[[sqlways:replicator-users-guide/description|Description]]** | * **[[sqlways:users-guide/setting-up-database-connection|How To Tune ODBC Connection to Source Database]]** |
* **[[sqlways:replicator-users-guide/tuning|Tuning]]** | * [[sqlways:users-guide/setting-up-database-connection/dsn_file|Connection Using the DSN File]] |
| * [[sqlways:users-guide/setting-up-database-connection/oracle|Oracle]] |
| * [[sqlways:users-guide/setting-up-database-connection/progress|Progress]] |
| * [[sqlways:users-guide/setting-up-database-connection/ase|Sybase Adaptive Server Enterprise]] |
| * [[sqlways:users-guide/setting-up-database-connection/asa|Sybase SQL Anywhere]] |
| * [[sqlways:users-guide/setting-up-database-connection/iq|Sybase IQ]] |
| * [[sqlways:users-guide/setting-up-database-connection/db2|DB2]] |
| * [[sqlways:users-guide/setting-up-database-connection/sql-server|Microsoft SQL Server]] |
| * [[sqlways:users-guide/setting-up-database-connection/mysql|MySQL]] |
| * [[sqlways:users-guide/setting-up-database-connection/postgresql|PostgreSQL]] |
| * [[sqlways:users-guide/setting-up-database-connection/firebird|Firebird]] |
| * [[sqlways:users-guide/setting-up-database-connection/informix|IBM Informix]] |
| * [[sqlways:users-guide/setting-up-database-connection/foxpro|FoxPro]] |
| * [[sqlways:users-guide/setting-up-database-connection/teradata|TeraData]] |
| * [[sqlways:users-guide/setting-up-database-connection/access|Access]] |
| * [[sqlways:users-guide/setting-up-database-connection/advantage|Advantage]] |
| * [[sqlways:users-guide/setting-up-database-connection/dbase|DBase]] |
| * [[sqlways:users-guide/setting-up-database-connection/pervasive|Pervasive]] |
| * [[sqlways:users-guide/setting-up-database-connection/sap-hana|SAP HANA]]\\ |
| |
===== On The Fly Data Migrator User's Guide ===== | |
| |
* **[[sqlways:OnTheFlyDataMigrator-users-guide/Description|Description]]** | * **[[sqlways:users-guide/check-list|Check List]]** |
| * [[sqlways:users-guide/check-list/setting-up-source-user-privileges|Setting Up Source User Privileges]] |
| * [[sqlways:users-guide/check-list/setting-up-target-user-privileges|Setting Up Target User Privileges]] |
| |
| |
| |
===== Application Conversion Cases ===== | ===== Application Conversion Cases ===== |
| |
| |
* **[[sqlways:cobol|COBOL]]** | * **[[sqlways:cobol|COBOL]]** |
* **[[sqlways:specifics/saphana|Sap Hana Migration]]** | * **[[sqlways:specifics/saphana|Sap Hana Migration]]** |
| |
| ===== Migration Guides ===== |
| |
===== SQLWays Wizard Troubleshooting Guide ===== | * [[sqlways:users-guide/migrate-progress4gl-to-mssql|How to Migrate Progress4GL to Microsoft SQL Server Using Command Line]] |
| * [[sqlways:users-guide/migrate-progress4gl-to-c-net|How To Migrate Progress 4GL to C# with Microsoft SQL Server Database Usage]] |
| * [[sqlways:users-guide/migrate-cobol-to-oracle|How to Migrate COBOL Code to Oracle PL\SQL]] |
| * [[sqlways:users-guide/migrate-mssql-to-postgres|How to Convert Microsoft SQL Server database to PostgreSQL]] |
| |
* **[[sqlways:troubleshooting-guide/oracle|Oracle]]** | ===== Tips and Tricks ===== |
* [[sqlways:troubleshooting-guide/oracle/export|Export]] | * **[[sqlways:tips-and-tricks|Tips and Tricks]]** |
* [[sqlways:troubleshooting-guide/oracle/import|Import]] | |
* **[[sqlways:troubleshooting-guide/sql-server|Microsoft SQL Server]]** | |
* [[sqlways:troubleshooting-guide/sql-server/export|Export]] | |
* [[sqlways:troubleshooting-guide/sql-server/import|Import]] | |
* **[[sqlways:troubleshooting-guide/db2|IBM DB2]]** | |
* [[sqlways:troubleshooting-guide/db2/export-conversion|Export and Conversion]] | |
* [[sqlways:troubleshooting-guide/db2/import-conversion|Import & Conversion]] | |
* **[[sqlways:troubleshooting-guide/MySQL|MySQL]]** | |
* [[sqlways:troubleshooting-guide/mysql/import| Import]] | |
* **[[sqlways:troubleshooting-guide/postgresql|PostgreSQL]]** | |
* [[sqlways:troubleshooting-guide/postgresql/export-conversion|Export and Conversion]] | |
* [[sqlways:troubleshooting-guide/postgresql/import|Import]] | |
* **[[sqlways:troubleshooting-guide/Progress|Progress]]** | |
* [[sqlways:troubleshooting-guide/progress/export-conversion|Export and Conversion]] | |
* **[[sqlways:troubleshooting-guide/Informix|Informix]]** | |
* [[sqlways:troubleshooting-guide/informix/export-conversion|Export and Conversion]] | |
* **[[sqlways:troubleshooting-guide/sap-hana|SAP Hana]]** | |
* [[sqlways:troubleshooting-guide/sap-hana/import|Import]] | |
| |
| ===== Documentation archive ===== |
| * [[sqlways:documentation-archive|You can find documentation for the outdated version of Ispirer software here]] |
| |
===== Frequently Asked Questions ===== | |
* [[sqlways:faq/light-installer|What to do if light installer fails to download the Ispirer MnMTK toolkit]] | |
* [[sqlways:faq/light-installer-assessment-wizard|What to do if light installer fails to download the Ispirer MnMTAK toolkit]] | |
* [[sqlways:faq/how-to-run-as-administrator|How to Run the Tools as Administrator]] | |
* [[sqlways:faq/expert-mode|How to use the SQLWays Wizard in "Expert mode"]] | |
* [[sqlways:faq/how-to-use-sqlways-wizard|How to Use the Ispirer SQLWays Wizard tool]] | |
* [[sqlways:faq/how-to-run-in-parallel-mode|How to Run the SQLWays Wizard in Parallel Mode]] | |
* [[sqlways:faq/migrate-to-existing-database|How to Migrate into Existing Database]] | |
* [[sqlways:faq/manage-errors|How does SQLWays manage errors?]] | |
* [[sqlways:faq/work-unix-systems|Whether SQLWays can work under Unix like systems]] | |
* [[sqlways:faq/optimize-migration-process-large-tables|How to Optimize the Migration Process for Large tables]] | |
* [[sqlways:faq/load-parameterization|Parameterize login information after import script generation]] | |
* [[sqlways:faq/change-decimal-point|How to Change a Decimal Point Character?]] | |
* [[sqlways:faq/export-file-formats|What Export File Formats are Supported by SQLWays?]] | |
* [[sqlways:faq/column-name-mapping|How to Change Column Name Mapping in SQLWays Wizard]] | |
* [[sqlways:faq/fk-convert|How to ensure that Foreign key is converted successfully from MySQL to SQL Server?]] | |
* [[sqlways:faq/recycle-bin|Why Does a Bunch of Invalid Objects with Garbage Names Appear in Oracle]] | |
* [[sqlways:faq/generate-ddl-without-data-export|How to Generate DDL Script without Data Export]] | |
* [[sqlways:faq/schedule-migration-process|How to Schedule the Migration Process]] | |
* [[sqlways:faq/dll-missing-from-your-computer| DLL Is Missing From Your Computer. How to solve it?]] | |
* [[sqlways:faq/convert-database-objects-to-java|Convert SQL Database Objects to Java in SQLWays Wizard]] | |
* [[sqlways:users-guide/test-features|How To Test Converted SQL Code]]\\ | |
| |
* **[[sqlways:users-guide/setting-up-database-connection|How To Tune ODBC Connection to Source Database]]** | |
* [[sqlways:users-guide/setting-up-database-connection/dsn_file|Connection Using the DSN File]] | |
* [[sqlways:users-guide/setting-up-database-connection/oracle|Oracle]] | |
* [[sqlways:users-guide/setting-up-database-connection/progress|Progress]] | |
* [[sqlways:users-guide/setting-up-database-connection/ase|Sybase Adaptive Server Enterprise]] | |
* [[sqlways:users-guide/setting-up-database-connection/db2|DB2]] | |
* [[sqlways:users-guide/setting-up-database-connection/sql-server|Microsoft SQL Server]] | |
* [[sqlways:users-guide/setting-up-database-connection/mysql|MySQL]] | |
* [[sqlways:users-guide/setting-up-database-connection/postgresql|PostgreSQL]] | |
* [[sqlways:users-guide/setting-up-database-connection/firebird|Firebird]]\\ | |
| |
| |
* **[[sqlways:users-guide/check-list|Check List]]** | |
* [[sqlways:users-guide/check-list/setting-up-source-user-privileges|Setting Up Source User Privileges]] | |
| |
\\ | ====== ====== |
[[http://www.ispirer.com|Ispirer Home Page]] | |
[[http://www.ispirer.com|Ispirer SQLWays Migration Product Page]] | |
[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]] | |