Convert IBM DB2 for i to Greenplum

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 Greenplum 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:

binary
bytea
blob
bytea
char
text (if precision > 10485760)
clob
text
double
double precision
integer
int
nchar
char (if precision <= 10485760)
nchar
text (if precision > 10485760)
nclob
text
nvarchar
varchar (if precision <= 10485760)
nvarchar
text (if precision > 10485760)
timestz
timestamptz
uniqueidentifier
uuid
varbinary
bytea

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
Greenplum-illustration
Step 2

Greenplum

We will select Greenplum 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.