https://wiki.ispirer.com/ 2026-04-28T00:40:32+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/column-name-mapping?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing How to Change Column Name Mapping in SQLWays Wizard There is a special option in the Wizard that lets you specify the column name mapping that you wish. You can find the information about this option using the following link: "Column name mapping". text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/convert-database-objects-to-java?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Java Conversion Pricing How to Сonvert SQL Database Objects to Java Using Ispirer Migration and Modernization Toolkit For certain migration directions you may need to convert database objects into Java syntax. For this purpose we included a special set of options in our tools. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/dll-missing-from-your-computer?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing DLL Is Missing From Your Computer. How To Solve it? Symptoms After installing Ispirer Migration and Modernization toolkit on your machine and trying to run the SQLWays Wizard you may see the system error message as shown below: Cause This system message may appear because VC++ 2015 runtime is missed on your working environment. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/fk-convert?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing How to ensure that Foreign key is converted successfully from MySQL to MSSQL Server? Foreign keys in MySQL and in MSSQL has the same structure. Structure of the Foreign key in the MSSQL: [ FOREIGN KEY ] REFERENCES [ schema_name . ] referenced_table_name [ ( ref_column ) ] [ ON DELETE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] [ ON UPDATE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ] text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/fk-convert2?rev=1741078744&do=diff Ispirer text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/generate-ddl-without-data-export?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing How to Generate DDL Script without Data Export In SQLWays you can export and convert only. For this purpose please uncheck the "Export Data" option. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/how-to-assess-logical-files?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing How To Collect Information About Logical Files To collect information about logical files from our DB2 database, we need to have DDS file for each logical file that should be assessed. At the “Choose a Source Database” page, in the “Advanced text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/how-to-change-data_type-mapping?rev=1741078744&do=diff article was migrated to other page text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/how-to-register?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing How To Register Ispirer MnMTK ToolKit If you run one of the tools from Ispirer Migration and Modernization Toolkit for the first time, you need to register the toolkit using the license information that you have. 1.1 Registration in SLQWays Wizard text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/how-to-run-as-administrator?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing How to Run the Tools as Administrator We recommend to run all the tools provided by Ispirer Systems using “Run as Administrator” option. In other case we can't guarantee that all information will be extracted and saved on local machine, where you running the tool. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/how-to-use-sqlways-wizard?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing How to Use the Ispirer SQLWays Wizard Tool Run the SQLWays Wizard as Administrator Note: Always run the SQLWays Wizard Tool using “as Administrator” option. You can do it in Windows Search panel, like it is done on the screenshot: Or you can go to the installation directory, right click on the icon and choose text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/indentifier-names-pg?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing How to preserve the identifiers names case when migration to PostgreSQL Please note, that in PostgreSQL unquoted names are always folded to lower case: <https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS> To enclose all the identifier names in quotes in target scripts you need to set the option text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/light-installer-assessment-wizard?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing What to do when light installer fails to download the Assessment Toolkit (Ispirer MnMATK) The size of the Ispirer MnMATK install file is about 0.7MB. When you run the install file, the installer downloads the Ispirer MnMATK application in the background. If there are problems with internet connection while downloading the file, the installer will recommence the download as soon as connection is restored. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/light-installer?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing What to do when light installer fails to download the Ispirer MnMTK toolkit The size of the Ispirer MnMTK install file is about 0.8MB. When you run the install file, the installer downloads the Ispirer MnMTK application in the background. If there are problems with internet connection while downloading the file, the installer will recommence the download as soon as connection is restored. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/load-parameterization?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing Parameterize login information after import script generation You can use environment variables to specify the SERVIСE, PASSWORD and USER for the whole run in sqlways_all.bat. But first you need to specify those environment variables in the SQLWays, so that it used them in all the bat files with the commands, like: text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/manage-errors?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing How does SQLWays manage errors? * There are three types of errors that might occur during the migration: * Export error – when our tool cannot recognize some part of the source code. In this case the error is raised on the export and depicted in the text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/recycle-bin?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing Why Does a Bunch of Invalid Objects with Garbage Names Appear in Oracle Prior to Oracle 10g, a DROP command permanently removed objects from the database. In Oracle 10g a DROP command places the object in the recycle bin. The extents allocated to the segment are not reallocated until you purge the object. You can restore the object from the recycle bin at any time. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/work-unix-systems?rev=1741078744&do=diff User Documentation Ispirer Toolkit Overview Pricing Whether SQLWays can work under Unix like systems There is a tool that is not included into the main SQLWays installation package which can be run on Unix like systems. This tool supports the migration of data only. It supports the following databases: text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/faq/zseries-oracle-migration-demo?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing IBM DB2 z/OS and OS/390 to Oracle Migration Demo Preparing for Migration * Install DB2 Connect, DB2 ODBC Driver and configure connection to DB2 z/OS from a PC where SQLWays installed. Guide on How to Do That * Install Oracle Client software and tune the TNS Service name for Oracle.