Convert MySQL 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 MySQL . 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:

bigint unsigned
bigint
binary
bytea
bit
boolean
blob
bytea
char
text (if precision > 10485760)
datetime
timestamp
double
double precision
enum
varchar(255)
float
real
geography
text (if spatial_supported is false)
geometry
text (if spatial_supported is false)
int unsigned
bigint
longblob
bytea
longtext
text
mediumblob
bytea
mediumint
int
mediumint unsigned
int
mediumtext
text
nchar
char (if precision <= 10485760)
nchar
text (if precision > 10485760)
nvarchar
varchar (if precision <= 10485760)
nvarchar
text (if precision > 10485760)
set
varchar(255)
smallint unsigned
int
tinyblob
bytea
tinyint
smallint
tinyint unsigned
smallint
tinytext
text
varbinary
bytea
year
int

Full Convert migration in 4 easy steps

Step 1

MySQL

We will choose MySQL from the source database engines list. As our MySQL server is on the local machine and we have full privileges, we will simply choose a database from the dropdown menu.

MySQL-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.