What are the best relational database migration tools?

Question

DevelopmentDatabasesMigrationSQLDatabase Managementreplication

What are the best relational database migration tools?

22

Options
Considered

65

User
Recs.

Jan 17, 2024

Last
Updated

19 Options Considered

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

See Full List

Fivetran

VersionSQL

Stitch

Phinx

See flagged products

Built By the Slant team

Find the best product instantly.

4.7 star rating

Try it now - it's free

score 1 · Answer 1

DataGrip

All

1

Specs

Platforms:Windows, Linux, Mac

Technology:Java

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

MySQL Workbench

All

1

Specs

Platforms:Windows, Linux, Mac

score 10 · Answer 4

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 5

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 2 · Answer 6

Liquibase

All

1

Specs

Platforms:Windows, Linux, Mac

score 3 · Answer 7

Dbmate

All

1

Specs

Platforms:Windows, Linux, Mac

Technology:Go

score 4 · Answer 8

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 9

Alooma

Top Con

Expensive

score 1 · Answer 10

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

score 1 · Answer 12

SQL Server Migration Assistant

Top Con

Limited scope

Only migrations to Microsoft databases are supported. See More

Top Pro

Free

RickZeeland's Experience

Microsoft SQL Server Migration Assistant (SSMA) allows database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE. See More

Top Con

No Postgres support

See All

score 1 · Answer 13

Replicator

Top Pro

Multi database

Almost 40 databases supported. See More

Top Con

Expensive

Specs

Platforms:Windows

See All

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 4 · Answer 16

19 Options Considered

My Recommendation for DataGrip

My Recommendation for DataGrip

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

My Recommendation for MySQL Workbench

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 Liquibase

My Recommendation for Liquibase

My Recommendation for Dbmate

My Recommendation for Dbmate

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 Alooma

My Recommendation for Alooma

Expensive

My Recommendation for SymmetricDS

My Recommendation for SymmetricDS

Limited free version

Multi database

Installs triggers

File systems

My Recommendation for dbMigration .NET

My Recommendation for dbMigration .NET

Limited free version

Supports multiple databases

Chaotic website

Migrates data

Portable

My Recommendation for SQL Server Migration Assistant

My Recommendation for SQL Server Migration Assistant

Limited scope

Free

No Postgres support

My Recommendation for Replicator

My Recommendation for Replicator

Multi database

Expensive

My Recommendation for Fivetran

My Recommendation for Fivetran

My Recommendation for VersionSQL

My Recommendation for VersionSQL

My Recommendation for Flyway

My Recommendation for Flyway

Multi database

My Recommendation for Stitch

My Recommendation for Stitch

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

My Recommendation for Phinx

My Recommendation for Phinx

Don't see your favorite option? Add it.

My Recommendation for DBConvert Studio

My Recommendation for DBConvert Studio

One sec!