Ispirer Migration Knowledge Base

• Assessment Wizard for Databases
• Migration Assessment Studio for Scripts

How to Use Assessment Wizard for Databases

• Description
• Installation Requirements

• SQLWays Wizard
  
  • Welcome Page
  • Source Database Page
  • Target Database Page
  • Specify Objects Page
  • DDL and Data Options Page
  • Export Options Page
  • Import Options Page
  • Summary Page
  • Conversion Results
    

• SQLWays Studio
  • Choosing Source and Target
  • Options Menu
    

• SQLWays Command Line
  • Database Migration in Batch Mode
  • Converting Scripts in Batch Mode
  • Command-line Options
  • sqlways.ini file
  • sqlways.xml file

How to Use the Ispirer SQLWays Wizard tool

• SQLWays Database Comparison Tool
  • Database Comparison in Batch Mode
  • Database Comparison Wizard
  • Supported Options per Database

• Description
• Tuning

• Description

• Java
• Sybase CT-LIB
• ODBC
• ADO.NET - Oracle

• Oracle
• Microsoft SQL Server
• IBM DB2
• MySQL
• PostgreSQL
• Sybase
• Informix
• Teradata
• HP Neoview
• Interbase/Firebird
• HiRDB
• Ingres

• COBOL
• Microsoft .NET
• Visual Basic
• Progress 4GL and OpenEdge ABL
• PowerBuilder
• Delphi
• Oracle Forms

• IBM DB2 Migration
• RedShift Migration
• Sap Hana Migration

• Oracle
  • Export
  • Import
• Microsoft SQL Server
  • Export
  • Import
• IBM DB2
  • Export and Conversion
  • Import & Conversion
• MySQL
  • Import
• PostgreSQL
  • Export and Conversion
  • Import
• Progress
  • Export and Conversion
• Informix
  • Export and Conversion
• SAP Hana
  • Import
• Sybase Adaptive Server Enterprise
  • Export
  • Import

• How to Migrate Progress4GL to Microsoft SQL Server Using Command Line
• How to Migrate Progress4GL to .NET Using Command Line
• How to Migrate COBOL Code to Oracle PL\SQL
• How to Convert Microsoft SQL Server database to PostgreSQL

• What to do if light installer fails to download the Ispirer MnMTAK toolkit
• How to Run the Tools as Administrator
• How To Collect Information about Logical Files

• What to do if light installer fails to download the Ispirer MnMTK toolkit
• How to Register the Ispirer MnMTK toolkit
• How to Run the Tools as Administrator
• How to use the SQLWays Wizard in "Expert mode"
• How to Use the Ispirer SQLWays Wizard tool
• How to Run the Conversion in Trace Mode
• How to Run the SQLWays Wizard in Parallel Mode
• How to Extract Piece of Data Using Conditions
• How to Migrate Data into Existing Database
• How does SQLWays manage errors?
• Whether SQLWays can work under Unix like systems
• How to Optimize the Migration Process for Large tables
• Parameterize login information after import script generation
• How to Change a Decimal Point Character?
• What Export File Formats are Supported by SQLWays?
• How to Change Column Name Mapping in SQLWays Wizard
• How to ensure that Foreign key is converted successfully from MySQL to SQL Server?
• Why Does a Bunch of Invalid Objects with Garbage Names Appear in Oracle
• How to Generate DDL Script without Data Export
• How to Schedule the Migration Process
• DLL Is Missing From Your Computer. How to solve it?
• How To Make Import Into SAP Hana Database
• Convert SQL Database Objects to Java in SQLWays Wizard
• How To Split Table Into Several Small Tables
• How To Test Converted SQL Code
• How To Convert and Import In Command Line Mode
• What DB2 AS400 Client To Use For ODBC Connection Tuning
• Utilities Used To Make Import
• How to change objects names during the migration
• How To Connect To PostgreSQL Database Using SSL Connection
  

• How to Generate .df File From Progress Database
• How to Load Definitions (.df file) and Data (.d file) to Progress Database

• How To Tune ODBC Connection to Source Database
  • Connection Using the DSN File
  • Oracle
  • Progress
  • Sybase Adaptive Server Enterprise
  • Sybase SQL Anywhere
  • Sybase IQ
  • DB2
  • Microsoft SQL Server
  • MySQL
  • PostgreSQL
  • Firebird
  • IBM Informix
  • FoxPro
  • TeraData
  • Access
  • Advantage
  • DBase
  • Pervasive
  • SAP HANA
    

• Check List
  • Setting Up Source User Privileges
  • Setting Up Target User Privileges

Ispirer Home Page Ispirer SQLWays Migration Product Page Request SQLWays