What are the best relational database migration tools?

Add to Chrome - It's Free

Built by Slant

Find the best product
instantly.

Stop wasting time searching endlessly. Lustre recommends the best products at their lowest prices – right on Amazon.

4.7 star rating

Add to Edge - It's Free

Add to Firefox - It's Free

Add to Opera - It's Free

Add to Brave - It's Free

Add to Safari - It's Free

Try now - it's free

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

PostgreSQL SQL Server MySQL / MariaDB SQLite Cassandra See More

score 7 · Answer 3

Evolve

Top Pro

Multi database

RickZeeland's Experience

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

Specs

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

score 5 · Answer 4

Data Puppy Lite

Top Pro

Free

RickZeeland's Experience

Specs

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

score 4 · Answer 5

gitSQL

Top Pro

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

Top Con

No update scripts

Specs

Platforms:Windows, Mac

Top Pro

Migrate data

Can script out data too. See More

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

score 2 · Answer 6

OraDump Export Kit

Top Pro

Many options to customize migration

Top Con

Does not migrate views, triggers, stored procedures

joshi.zoy's Experience

Specs

Top Pro

Easy to use interface

score 1 · Answer 7

Liquibase

Almost 40 databases supported. See More

score 1 · Answer 8

Replicator

Top Pro

Multi database

Top Con

Expensive

Specs

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

score 1 · Answer 9

Alooma

Top Con

Expensive

score 1 · Answer 10

SymmetricDS

Top Con

Limited free version

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

Technology:Java

Top Con

Installs triggers

SymmetricDS does install database triggers. See More

Top Pro

File systems

Can also duplicate entire file systems. See More

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

score 1 · Answer 11

dbMigration .NET

Top Con

Limited free version

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

Portable version. See More

Top Pro

Migrates data

Top Pro

Portable

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

score 1 · Answer 12

Flyway

Top Pro

Multi database

Specs