Convert IBM DB2 for i to SAP IQ

Full Convert is designed for ease of use and reliability to make sure you get your job done as quickly and as simply as possible.

FC-Tutorial-Shape

Making migration easy for you

Full Convert is a fully self-tuning software. Your migration will work as expected without you needing to adjust anything.

Data types are different in SAP IQ compared to IBM DB2 for i . We automatically adjust them as we copy the tables so you don't have to worry about it. You can adjust the mapping rules if you wish to change the following defaults:

blob
long binary
boolean
bit
char
long varchar (if precision > 32768)
clob
long varchar
double
real
integer
int
nchar
char (if precision <= 32768)
nchar
long varchar (if precision > 32768)
nclob
long varchar
nvarchar
varchar (if precision <= 32768)
nvarchar
long varchar (if precision > 32768)
real
float
timestz
timestamp
varbinary
long binary (if precision > 32768)
varchar
long varchar (if precision > 32768)
xml
long varchar

Full Convert migration in 4 easy steps

Step 1

IBM DB2 for i

We will select IBM DB2 for i from the drop down and fill out the connection parameters.

IBM DB2 for i-illustration
SAP IQ-illustration
Step 2

SAP IQ

We will select SAP IQ from the drop down and fill out the connection parameters.

Step 3

Start the conversion

All source tables are selected for conversion by default. In case you only need some tables, simply deselect the ones you don't need - or deselect all, then select just the tables you do need. Click the Copy your database button to get started.

Click the Copy your database button to get started.

project-overview-illustration
copying-data-illustration
Step 4

Conversion

Conversion is highly-optimized to run as fast as possible, yet provides top-notch reliability. Huge tables are converted in small chunks at a time, preserving memory and ensuring that your computer stays fast and responsive.

Data is now in the target database

Use our built-in database browser to examine the copied data.

target-database-browser-illustration

Of course, you can also examine the conversion in detail and see in-depth information for each table.