Ecosystem:Data migration

From PostgreSQL wiki
Jump to navigationJump to search

DBConvert

  • Provider -- Slotix s.r.o.
  • Website -- https://dbconvert.com/postgresql/
  • License -- proprietary
  • Interoperability level -- supports PostgreSQL
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-1
  • Description -- The DBConvert product line covers all the most popular migration and synchronization directions, allowing users to convert and replicate data between Postgres/ Amazon RDS for PostgreSQL/ Heroku Postgres and other database engines.
  • Additional info -- click here

DataDiff

  • Provider -- Datanamic Solutions
  • Website -- https://www.datanamic.com/datadiff/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 7 or higher
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-1
  • Description -- Datanamic DataDiff is a powerful and easy-to-use utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly and safely. Flexible comparison and synchronization settings will enable you to set up a customized comparison key and to select tables and fields for comparison and for synchronization. Datanamic DataDiff can be used for data migrations, verification of (corrupt) data, data auditing etc. For each supported database, database specific comparison and synchronization routines are used.
  • Additional info -- click here

DataPro

  • Provider --
  • Website -- http://www.vive.net/products/datapro.htm
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 7.x - 9.x
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-1
  • Description -- dataPro offers cutting-edge, high-efficiency database management, migration and transformation solution. dataPro is visual cross-platform database tool with Explorer like interface designed for database management, database development and database conversion. Transfer database objects beetwen different databases and servers, convert tables schema and migrate data from one database type to another. dataPro supports data conversion and database migration for PostgreSQL, Oracle, Microsoft SQL Server, Microsoft Access, MySQL and SQLite.
  • Additional info -- click here

dbForge Studio for PostgreSQL

dbForge Data Compare for PostgreSQL

EDB Postgres Migration Toolkit

  • Provider -- EnterpriseDB Corporation
  • Website -- https://www.enterprisedb.com/products/edb-postgres-platform/edb-migration-toolkit
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 9.x or higher
  • Verified PostgreSQL versions -- 9.5 and higher
  • Last update (YYYY-MM-DD) -- 2017-6-7
  • Description -- EDB Postgres Migration Toolkit migrates Oracle, SQL Server and MySQL data to PostgreSQL providing online/offline schema/data migration with flexible customization and fast parallel data loading. Online migrates your source database directly into PostgreSQL making it available for immediate use. Offline creates DDL scripts that can be edited and run at a later scheduled time.
  • Additional info -- click here

ESF Database Migration Toolkit

  • Provider -- DBSofts Inc.
  • Website -- https://www.easyfrom.net/jp/https://www.dbsofts.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 7.x or higher
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-1
  • Description -- Allows you to migrate data between various database formats in 3 steps without any scripting! This software can help you quickly migrate a variety of data, structures and objects, saving you a lot of time and money. It will automatically migrate all table structures, data, schemas(Oracle, SQL Server 2000 or higher, PostgreSQL, IBM DB2 and so), LOBs(Large Text/Binary Objects), primary/foreign keys, indexes, auto-increment(serial), comments and default values and more. This software uses the latest and most advanced migration technology for systems with a variety of data volumes. It features DBMS Native API and bulk-insert technology that can enhance productivity by speeding up the entire migration process. Our customers success by using this tool to migrate Carrier-Grade database with multi-million records (SQL Server to Oracle)!
  • Additional info -- click here

Full Convert

  • Provider -- Spectral Core Ltd
  • Website -- https://www.spectralcore.com/fullconvert
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (version unknown)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-1
  • Description -- Full Convert is the easiest way to copy your data from existing database to another. We handle all popular and even ancient databases of any size. A high-speed database converter carefully creates your tables in a new database, then copies all your data. Indexes and table relationships are preserved.
  • Additional info -- click here

Skyvia

  • Provider -- Devart Ltd.
  • Website -- https://skyvia.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (version unknown)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- Skyvia is a SAAS that provides Data integration, backup, management, and connectivity.
  • Additional info -- click here

SQL::Translator

  • Provider -- SQL::Translator authors
  • Website -- https://metacpan.org/pod/SQL::Translator
  • License -- open source (Artistic License)
  • Interoperability level -- explicitly supports PostgreSQL (version unknown)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- SQL::Translator (AKA "SQLFairy") is a collection of modules for transforming (mainly) SQL DDL files into a variety of other formats, including other SQL dialects, documentation, images, and code.
  • Additional info -- click here