mysql-to-postgres - MySQL to PostgreSQL Data Translation

MRI or jruby supported.

With a bit of a modified rails database.yml configuration, you can integrate mysql-to-postgres into a project.

Installation

Via RubyGems

gem install mysqltopostgres

From source

git clone https://github.com/maxlapshin/mysql2postgres.git
cd mysql2postgres
bundle install
gem build mysqltopostgres.gemspec
sudo gem install mysqltopostgres-0.2.20.gem

Sample Configuration

Configuration is written in YAML format and passed as the first argument on the command line.

default: &defaultadapter: jdbcpostgresqlencoding: unicodepool: 4username: terrapotamuspassword: defaulthost: 127.0.0.1development: &development<<: *defaultdatabase: default_developmenttest: &test<<: *defaultdatabase: default_testproduction: &production<<: *defaultdatabase: default_productionmysql_data_source: &piihostname: localhostport: 3306socket: /tmp/mysqld.sockusername: usernamepassword: defaultdatabase: awesome_possummysql2psql:
mysql:
<<: *piidestination:
production:
<<: *productiontest:
<<: *testdevelopment:
<<: *developmenttables:
- countries
- samples
- universes
- variable_groups
- variables
- sample_variables# If suppress_data is true, only the schema definition will be exported/migrated, and not the datasuppress_data: false# If suppress_ddl is true, only the data will be exported/imported, and not the schemasuppress_ddl: true# If force_truncate is true, forces a table truncate before table loadingforce_truncate: falsepreserve_order: trueremove_dump_file: truedump_file_directory: /tmpreport_status: json # false, json, xml# If clear_schema is true, the public schema will be recreated before conversion# The import will fail if both clear_schema and suppress_ddl are true.clear_schema: false

Please note that the MySQL connection will be using socket in case the host is not defined (nil) or it is 'localhost'.