What are the best relational database migration tools?

Question

18

Options
Considered

56

User
Recs.

Nov 28, 2022

Last
Updated

Here’s the Deal

16 Options Considered

Best relational database migration tools	Price	Platforms	Technology
-- MySQL Workbench	Free / paid	Windows, Linux, Mac	-
-- Navicat for MySQL	$299	-	-
-- Evolve	Free	Windows, Linux, Mac	-
-- Data Puppy Lite	Free	Windows	-
-- Dbmate	Free	Windows, Linux, Mac	Go

See Full List

Phinx

See flagged products

I Recommend...

Built By the Slant team

Find the best product instantly.

4.7 star rating

Try it now - it's free

score 9 · Answer 1

MySQL Workbench

Platforms:Windows, Linux, Mac

score 6 · Answer 2

Navicat for MySQL

Top Pro

Batch job scheduling

Navicat can schedule things like backups, restores, data transfers or report building. See More

MemorableVellamo's Experience

I wanted to migrate data from a local MySQL instance to Amazon RDS. I found Navicat for MySQL's Migration tool to be extremely effective for this purpose. It includes a wizard that guided me through the process. It also provided many options such as whether or not to create records, use transactions, continue ion error, etc. See More

Top Pro

Data and structure synchronization

Navicat can compare and synchronize your data and structure between local and remote databases. See More

Top Pro

HTTP/SSH tunnel

Navicat can upload a PHP script to enable HTTP tunneling or choose a SSH tunnel instead. See More

Top Pro

Excellent choice of import/export options

Navicat can easily import data from ODBC, Excel, Access, DBF, TXT, CSV, XML, JSON etc and export to Excel, Access, DBF, TXT, CSV, XML, JSON etc. See More

See All

score 9 · Answer 3

Evolve

Top Pro

Multi database

PostgreSQL SQL Server MySQL / MariaDB SQLite Cassandra Cockroach DB See More

RickZeeland's Experience

Evolve is an open source database migration tool for .NET and .NET Core, inspired by Flyway. See More

Specs

Platforms:Windows, Linux, Mac

See All

score 6 · Answer 4

Data Puppy Lite

Top Pro

Free

RickZeeland's Experience

Simple tool that supports MySQL, SQL Server, PostgreSQL, and Oracle. See More

Specs

Platforms:Windows

See All

score 3 · Answer 5

Dbmate

Platforms:Windows, Linux, Mac

Technology:Go

score 2 · Answer 6

Liquibase

Platforms:Windows, Linux, Mac

score 4 · Answer 7

gitSQL

Top Pro

Direct reading Oracle dump files, can either create new table(s) or merge into existing

Top Con

No update scripts

Does not seem to provide update scripts, only create scripts for the full database and data. When you have an existing production database, you do not want to re-create the database. See More

Specs

Platforms:Windows, Mac

Top Pro

Migrate data

Can script out data too. See More

See All

score 1 · Answer 8

Replicator

Top Pro

Multi database

Almost 40 databases supported. See More

Top Con

Expensive

Specs

Platforms:Windows

See All

score 1 · Answer 9

SymmetricDS

Top Con

Limited free version

The free version does not have a GUI and can only be used from the command line, see comparison. There is an open source GUI dashboard available however: DRD Replicator. See More

Top Pro

Multi database

Support for Oracle, MySQL, MariaDB, PostgreSQL, MS SQL Server (including Azure), IBM DB2 (UDB, iSeries, and zSeries), H2, HSQLDB, Derby, Firebird, Interbase, Informix, Greenplum, SQLite, Sybase ASE, Sybase ASA (SQL Anywhere), Amazon Redshift, MongoDB, and VoltDB. See More

RickZeeland's Experience

Java based open source software supporting cross platform database replication between different databases. See More

Specs

Platforms:Windows, Linux, Mac, Android

Top Con

Installs triggers

SymmetricDS does install database triggers. See More

Top Pro

File systems

Can also duplicate entire file systems. See More

See All

score 1 · Answer 10

Alooma

Top Con

Expensive

score 1 · Answer 11

dbMigration .NET

Top Con

Limited free version

Free version is limited to 10000 rows per table. See More

Top Pro

Supports multiple databases

Lots of databases supported. See More

RickZeeland's Experience

One of the few free database migration tools, free for personal use. See More

Specs

Platforms:Windows

Top Con

Chaotic website

The website gives a bad impression of an otherwise impressive product. See More

Top Pro

Migrates data

Top Pro

Portable

Portable version. See More

See All

Answer 12

Stitch

Add Video or Image

Answer 13

Fivetran

Add Video or Image

score 2 · Answer 14

Flyway

Top Pro

Multi database

Oracle SQL Server DB2 MySQL Aurora MySQL MariaDB Percona XtraDB Cluster PostgreSQL Aurora PostgreSQL Redshift CockroachDB SAP HANA Sybase ASE Informix H2 HSQLDB Derby SQLite See More

Specs

Platforms:Windows, Linux, Mac

score 2 · Answer 15

OraDump Export Kit

Top Pro

Many options to customize migration

Top Con

Does not migrate views, triggers, stored procedures

joshi.zoy's Experience

The product has easy to use interface and was able to migrate all Oracle data within just few mouse clicks. I saw that it can also migrate into MySQL, SQL Server and even MS Access, however I didn't need those options. See More

Specs

Platforms:Windows

Top Pro

Easy to use interface

See All

score 1 · Answer 16

SWAN - Data Migration Tool

score 1 · Answer 17

16 Options Considered

My Recommendation for MySQL Workbench

My Recommendation for MySQL Workbench

My Recommendation for Navicat for MySQL

My Recommendation for Navicat for MySQL

Batch job scheduling

Data and structure synchronization

HTTP/SSH tunnel

Excellent choice of import/export options

My Recommendation for Evolve

My Recommendation for Evolve

Multi database

My Recommendation for Data Puppy Lite

My Recommendation for Data Puppy Lite

Free

My Recommendation for Dbmate

My Recommendation for Dbmate

My Recommendation for Liquibase

My Recommendation for Liquibase

My Recommendation for gitSQL

My Recommendation for gitSQL

Direct reading Oracle dump files, can either create new table(s) or merge into existing

No update scripts

Migrate data

My Recommendation for Replicator

My Recommendation for Replicator

Multi database

Expensive

My Recommendation for SymmetricDS

My Recommendation for SymmetricDS

Limited free version

Multi database

Installs triggers

File systems

My Recommendation for Alooma

My Recommendation for Alooma

Expensive

My Recommendation for dbMigration .NET

My Recommendation for dbMigration .NET

Limited free version

Supports multiple databases

Chaotic website

Migrates data

Portable

My Recommendation for Stitch

My Recommendation for Stitch

My Recommendation for Fivetran

My Recommendation for Fivetran

My Recommendation for Phinx

My Recommendation for Phinx

My Recommendation for Flyway

My Recommendation for Flyway

Multi database

My Recommendation for OraDump Export Kit

My Recommendation for OraDump Export Kit

Many options to customize migration

Does not migrate views, triggers, stored procedures

Easy to use interface

Don't see your favorite option? Add it.

My Recommendation for SWAN - Data Migration Tool

My Recommendation for SWAN - Data Migration Tool

My Recommendation for ESF Database Migration Toolkit

My Recommendation for ESF Database Migration Toolkit

One sec!