https://support.ispirer.com/ 2026-04-21T09:56:23+0000 https://support.ispirer.com/ https://support.ispirer.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2023-10-20T15:56:10+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/access?rev=1697817370&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Access Source ODBC Connection Tune * ODBC Driver Configuration text/html 2023-10-20T16:15:26+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/advantage?rev=1697818526&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Advantage Source ODBC Connection Tune * ODBC Driver Installation * ODBC Driver Configuration text/html 2023-10-20T16:16:56+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/aurora-mysql?rev=1697818616&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Amazon Aurora (compatibility with MySQL) Target Settings * Bin Directory and Utilities to Perform Import text/html 2023-10-20T16:25:54+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/aurora-postgresql?rev=1697819154&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Amazon Aurora (compatibility with PostgreSQL) Target Settings * Bin Directory and Utilities to Perform Import text/html 2023-10-23T17:57:24+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/azure-sql?rev=1698083844&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Azure SQL Database Target Settings * Bin Directory and Utilities to Perform Import text/html 2023-10-23T18:03:28+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/azure-synapse?rev=1698084208&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Azure Synapse Analytics Target Settings * Bin Directory and Utilities to Perform Import text/html 2025-04-10T08:00:58+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/connecting_to_an_oracle_database_server_authenticated_by_kerberos?rev=1744272058&do=diff Ispirer Website Ispirer Capabilities: Oracle Migration Free Trial Connecting to an Oracle Database Server Authenticated by Kerberos Generally, all the necessary settings need to be done in Net Manager/ in sqlnet.ora, because the working local service name is required to use the ODBC, but the algorithm is supposed to be the following: text/html 2023-10-25T11:41:49+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/db2-as400?rev=1698234109&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial IBM DB2 AS/400 (iSeries) Source ODBC Connection Tune * ODBC Driver Configuration * Which DB2 AS/400 Client to Use Troubleshooting * SQL Error Code: -204 SQL State: 42704 com.ibm.db2.jdbc.app.DB2 *FIRST in *N type *MEM Not Found * SQL5016 - Qualified Object Name Not Valid * How to Extract Logical and Physical Files from DB2 iSeries (AS/400) * Convert Logical Files from DB2 AS/400 * Convert Multi-Member Tables from DB2 AS… text/html 2023-10-24T18:02:05+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/db2-luw?rev=1698170525&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial IBM DB2 LUW Source ODBC Connection Tune * ODBC Driver Installation * ODBC Driver Configuration Settings * Source User Privileges Troubleshooting * DataSaver Exception * SQL0443N Routine "SYSIBM.SQLCOLUMNS" has Returned an Error ---------- Target Settings * Bin Directory and Utilities To Perform Import Tool Specifics * Advanced Options text/html 2025-05-05T13:55:06+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/db2-zos?rev=1746453306&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial IBM DB2 z/OS (OS/390) Source ODBC Connection Tune * ODBC Driver Configuration Troubleshooting * Sequences conversion approach text/html 2023-10-23T18:08:21+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/dbase?rev=1698084501&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial DBase Source ODBC Connection Tune * ODBC Driver Configuration text/html 2025-06-03T15:23:48+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/dsn-file-connection?rev=1748964228&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Connection Using DSN File SQLWays has the possibility to work with the databases using the DSN file. File DSN is the file-based data source containing connection options for the database. File DSN is very useful when e.g. you need to tune the same connection on another PC that has the same driver installed. In this case you can just copy file DSN to this PC and use it for connection. text/html 2023-10-23T18:18:30+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/enterprisedb?rev=1698085110&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial EnterpriseDB Target Settings * Bin Directory and Utilities to Perform Import text/html 2023-10-23T18:23:48+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/firebird?rev=1698085428&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Firebird Source ODBC Connection Tune * ODBC Driver Installation * ODBC Driver Configuration text/html 2023-10-23T18:40:45+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/foxpro?rev=1698086445&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial FoxPro Source ODBC Connection Tune * ODBC Driver Installation * ODBC Driver Configuration text/html 2023-10-23T18:53:16+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/greenplum?rev=1698087196&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Greenplum Target Settings * Bin Directory and Utilities to Perform Import text/html 2023-10-25T11:50:59+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/informix?rev=1698234659&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Informix Source ODBC Connection Tune * ODBC Driver Installation * ODBC Driver Configuration Settings * Source User Privileges Troubleshooting * Function Sequence Error * Inexact Character Conversion During Translation * Export Process Takes Much Time * Informix Cannot Sort Rows ---------- Target Settings * Bin Directory and Utilities To Perform Import text/html 2023-10-25T13:40:01+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/interbase?rev=1698241201&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial InterBase Source ODBC Connection Tune * ODBC Driver Installation * ODBC Driver Configuration text/html 2023-10-25T14:28:28+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/mariadb?rev=1698244108&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial MariaDB Target Settings * Bin Directory and Utilities to Perform Import text/html 2024-01-16T14:33:11+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/mysql?rev=1705415591&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial MySQL Source ODBC Connection Tune * ODBC Driver Installation * ODBC Driver Configuration Settings * Source User Privileges ---------- Target Settings * Target User Privileges * Bin Directory and Utilities to Perform Import Troubleshooting * ERROR 1067 (42000) Invalid Default Value for / ERROR 1292 (22007) Incorrect Datetime Value: - Zero Date is Not Accepted by Timestamp * ERROR 1419 (HY000): You Do Not Have the SUP… text/html 2023-10-23T18:58:00+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/netezza?rev=1698087480&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial IBM Netezza Target Settings * Bin Directory and Utilities to Perform Import text/html 2025-10-30T08:11:05+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/oracle?rev=1761811865&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Oracle Source ODBC Connection Tune Windows * ODBC Driver Installation for Windows * TNS Service Name Configuration * ODBC Driver Configuration for Windows Linux * ODBC Driver Installation for Linux * ODBC Driver Configuration for Linux Settings * Source User Privileges * Connecting to an Oracle Database Server Authenticated by Kerberos Troubleshooting * ORA-00942: Table or View Does Not Exist * Prese… text/html 2023-10-26T15:02:50+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/pervasive?rev=1698332570&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Pervasive Source ODBC Connection Tune * ODBC Driver Installation * ODBC Driver Configuration text/html 2026-04-17T13:29:15+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/postgresql?rev=1776432555&do=diff Ispirer Website Ispirer Capabilities: PostgreSQL Migration Free Trial PostgreSQL Source ODBC Connection Tune * ODBC Driver Installation * ODBC Driver Configuration Settings * Source User Privileges Troubleshooting * There are No Columns in the Result Set * Out of Memory while Reading Tuples * Character with Byte Sequence <unicode sequence> in Encoding "UTF8" has No Equivalent in Encoding "WIN1252" ---------- Target Settings * Target User Privileges Troubleshooting… text/html 2023-10-27T16:00:17+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/progress?rev=1698422417&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Progress Source ODBC Connection Tune * ODBC Driver Installation * ODBC Driver Configuration * Driver Configuration Advanced Tab Settings * Starting Database Using Progress Explorer Tool Troubleshooting * Lock Table is Full (7870) * Column Origin in Table has Value Exceeding its Max Length or Precision * [OpenLink][ODBC][Progress Server]** Unable to Understand After -- "DECLARE" text/html 2026-04-17T13:28:43+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/redshift?rev=1776432523&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Amazon Redshift Target Settings * DDL and Data Migration text/html 2023-10-31T16:12:38+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sap-hana?rev=1698768758&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial SAP HANA Source ODBC Connection Tune * ODBC Driver Configuration ---------- Target Tool Specifics * DDL and Data Migration to SAP HANA * Convert Tables to CDS Format * Advanced Options text/html 2024-04-22T13:18:14+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server?rev=1713791894&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Microsoft SQL Server Source ODBC Connection Tune Windows * ODBC Driver Installation for Windows * ODBC Driver Configuration for Windows Linux * ODBC Driver Installation for Linux * ODBC Driver Configuration for Linux Settings * Source User Privileges Troubleshooting * TCP Provider: Error code 0x2746", SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol] ---------- … text/html 2023-10-31T13:59:31+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sybase-asa?rev=1698760771&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Sybase Adaptive Server Anywhere (ASA) Source ODBC Connection Tune * ODBC Driver Installation * ODBC Driver Configuration Settings * Source User Privileges ---------- Target Settings * Bin Directory and Utilities to Perform Import Tool Specifics * Advanced Options text/html 2025-05-05T12:30:19+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sybase-ase?rev=1746448219&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Sybase Adaptive Server Enterprise (ASE) Source ODBC Connection Tune * ODBC Driver Installation * ODBC Driver Configuration Settings * Source User Privileges Troubleshooting * ASE Error SQL207 - Invalid Column Name Error in Trace File * Exporting DDL objects from the database ---------- Target Troubleshooting * Requested Server Name Not Found Tool Specifics * Advanced Options text/html 2023-10-31T15:57:21+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sybase-iq?rev=1698767841&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Sybase IQ Source ODBC Connection Tune * ODBC Driver Configuration ---------- Target Settings * Bin Directory and Utilities to Perform Import Tool Specifics * Advanced Options text/html 2023-10-31T16:34:16+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/teradata?rev=1698770056&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Teradata Source ODBC Connection Tune * ODBC Driver Installation * ODBC Driver Configuration Settings * Source User Privileges ---------- Target Tool Specifics * Advanced Options