How to make a proper migration from MySQL to PostgreSQL ...There are no more Morse code exams for any class of ham license. ... There are various reasons you might want to get the Extra class license: To have full ...
Pure Chat has everything small businesses need to offer instant answers on their
websites and ... Create a more effective, personal online experience ... or tablet
when you have Pure Chat's desktop and mobile-optimized chat box on your site.Converting MySQL to PostgreSQL - Wikibooks, open books for an ...
DBConvert for MySQL and PostgreSQL
Converting from other Databases to PostgreSQL Contents Non-specific Full Convert Database conversion from more than 30 database engines to PostgreSQL and back pgloader knows how to
Converting from other Databases to PostgreSQL
Contents
Non-specific
Full Convert Database conversion from more than 30 database engines to PostgreSQL and back
pgloader knows how to load data from MySQL, SQLite, MS SQL Server, dBase files, CSV files and fixed-width data files, and more. Released under The PostgreSQL Licence.
DBConvert PostgreSQL database migration and sync software Database conversion and synchronization between PostgreSQL/ Amazon RDS, MySQL, MS SQL Server, SQL Azure, Oracle, MS Access.
Converting data between PostgreSQL and others database formats ESF Database Migration Toolkit enables you to transfer data across various databases, supporting PostgreSQL, MySQL, Oracle, SQL Server, IBM DB2, Informix, Microsoft Access, Microsoft Excel, dBase, Foxpro, Firbird, SQLite etc. - by Martin Williams
Comparison of different SQL implementations by Troels Arvin (covers PG 8.4 and MySQL 5.0)
Transactional DDL in PostgreSQL: A Competitive Analysis by Greg Smith
Migrating from one database to another with Pentaho ETL by Nicola Benaglia
dataPro Conversion tool for PostgreSQL, SQLite, MySQL, Oracle, SQL Server and Microsoft Access. Transfer database objects between different databases and servers, convert tables schema and migrate data from one database type to another.
DataDiff CrossDB is a Windows GUI utility to compare and synchronize/transfer data from PostgreSQL to/from Oracle, MSSQL, MS Access or MySQL databases.
PostgreSQL Data Wizard is a Windows GUI utility to transfer both schema and data from any ADO-compatible source (like MS Access, MySQL, SQL Server, Oracle, etc) to PostgreSQL.
SQL::Translator is a Perl module for translating table definitions between different software.
Foreign data wrappers may be useful for exporting data from other databases
Postgres Migration Toolkit Software pack to convert Oracle, MySQL, SQL Server and FoxPro to PostgreSQL, and vice versa.
Skyvia Web service for cloud data integration for PostgreSQL with Salesforce, Dynamics CRM, SugarCRM, Zoho CRM, QuickBooks, FreshBooks, ExactTarget, MailChimp, Bigcommerce, MySQL, SQL Server, SQL Azure, Amazon RDS.
OmniDB Open source web tool for database management and conversion. Currently supports PostgreSQL, Oracle, MariaDB, MySQL, Firebird, SQLite, MS Access, MS SQL Server, MS SQL Compact. OmniDB converts from any supported RDBMS to PostgreSQL and back.
DBase II, III, IV+ / DBF Format
FoxPro-to-PostgreSQL a program to migrate FoxPro databases to PostgreSQL server. The program does not use ODBC or any other middleware software. Command line support allows to script, automate and schedule the conversion process.
Full Convert Database conversion from DBF (dBase, Clipper, Visual FoxPro and other DBF variants) to PostgreSQL and back
pgloader by Dimitri Fontaine
Convert .dbf files into PostgreSQL by Tomasz Judycki
A Visual Basic utility to convert Dbase III, IV, and V by Dennis Bazan
Porting data from dBASE IV to PostgreSQL by Vijay Deval (2002-09-07)
PgDBF : Simplified and optimized replacement for XBaseToPg by Kirk Strauser
FileMaker Pro
IBM DB2
Interbase
Microsoft Access
Linking to MS Access tables with ogr_fdw If your PostgreSQL is on windows, you can use ogr_fdw foreign data wrapper, packaged with PostGIS 2.2+ bundle for windows via application stackbuilder. With PostgresQL 9.5, you can use IMPORT FOREIGN SCHEMA to link in all the MS access tables and then cherry pick how you want to restructure.
exportSQL - a Microsoft Access module which exports Access Database into MySQL, mSQL and PostgreSQL by Dobrica Pavlinusic. Based on the work of Pedro Freire
Full Convert Database conversion from more than 30 database engines, including Access, to PostgreSQL and back
MDB Tools by Brian Bruns
A quick way to dump all tables as tsv or csv files
If the tablenames have embedded spaces.
A shell script that may be useful for converting entire databases:
If this script is saved to the file access2psql.sh and made executable, then it would be used as follows:
This script won't work properly if there are tab characters in text columns, though the call to mdb-export could be modified to export INSERT statements to fix this. Also, mdb-schema has trouble representing multi-column foreign keys, so foreignkeys.sql may need some manual editing.
Microsoft SQL Server
MSSQL-to-PostgreSQL is a migration utility to convert SQL Server or SQL Azure databases to PostgreSQL. Option to filter data using SELECT-queries, synchronization mode, command line support.
Full Convert Database conversion from more than 30 database engines, including SQL Server, to PostgreSQL and back
[sqlserver2pgsql ] Migration tool to convert a Microsoft SQL Server Database into a PostgreSQL database
pgloader by Dimitri Fontaine
DBConvert for PostgreSQL and MS SQL Server Conversion and Sync software solutions for cross database migration between PostgreSQL/ Amazon RDS and MS SQL Server/ SQL Azure
Learning PostgreSQL (Alexander Kuznetsov) - series of blog articles for SQL Server users (2013-10
MySQL
Scripts, programs
2015
MySQL-to-PostgreSQL is a program to migrate MySQL databases to PostgreSQL server. Option to filter data using SELECT-queries, synchronization mode, command line support.
FromMySqlToPostgreSql migration tool by Anatoly Khaytovich. provides an accurate migration of table data, indices, PKs, FKs. Makes an extensive use of PostgreSQL COPY protocol.
2014
2013
Previously
Free MySQL to Postgres Migration Wizard by EnterpriseDB v1.1 by EnterpriseDB Corporation. Available without registration via PostgreSQL installer wizard.
Conversion tool for migrating from MySQL to PostgreSQL by PostgreSQL Inc.
Converting MySQL to PostgreSQL - from en.wikibooks.org
Migrate MySQL to PostgreSQL. - Cross database bidirectional synchronization
my2pg.pl - A Perl script used to convert a MySQL database dump to PostgreSQL-compatible format, by Maxim Rudensky and Valentine Danilchuk
mysql2pgsql - A Perl script used to convert MySQL databases dump to a PostgreSQL-compatible format
MySQL PHP to PostgreSQL by Michael Kohn
PHP_my2pg PHP script by Gabriel Bordeaux
Migrating from MySQL to Postgresql with Django blogpost by alejandro
Migrates MySQL to PostgreSQL Ruby script by Max Lapshin
py-mysql2pgsql Python script to convert MySQL database to PostgreSQL compatible file or export directly to a PostgreSQL server
my2pg.py MySQL to PostgreSQL database conversion (not the same as above)
SQL Data Definition Language (DDL) Conversion to MySQL, PostgreSQL and MS-SQL by phpBB Group
Documentation
Oracle
Utilities, tools, scripts etc.
Full Convert Database conversion from more than 30 database engines to PostgreSQL and back
Database migration for Oracle and PostgreSQL Software for cross - database conversion and sync between Oracle and PostgreSQL.
Ora2Pg - Oracle to PostgreSQL database schema converter by Gilles Darold
PostgreSQL Foreign Data Wrapper for Oracle (oracle_fdw) - an FDW providing support to access Oracle databases from within PostgreSQL
Orafce - implements common Oracle functions in PostgreSQL for compatibility
Oracle-to-PostgreSQL - a program to migrate Oracle databases to PostgreSQL server. The program has high performance due to direct connection to data source and destination databases (it does not use ODBC or any other middleware software). Command line support allows to script, automate and schedule the conversion process.
Documentation, articles, presentations etc.
PostgreSQL documentation
Articles and presentations (in reverse chronological order)
Progress RDBMS
Converting PostgreSQL Databases to other Databases
PostgreSQL to InterBase dump file converter by Dobrica Pavlinusic
Full Convert Database conversion from PostgreSQL to more than 30 database engines
OmniDB Open source web tool for database management and conversion. Currently supports PostgreSQL, Oracle, MariaDB, MySQL, Firebird, SQLite, MS Access, MS SQL Server, MS SQL Compact. OmniDB converts from any supported RDBMS to PostgreSQL and back.
You need to be a member of On Feet Nation to add comments!
Join On Feet Nation