Tired of your old DB2 databases ? Here’s a new migration kit that will ship your data to PostgreSQL !
Move from DB2 to Postgres in 8 simple Steps
1- Extract your database schema with
db2look. This will generate a db2 SQL script
db2topg.pl against the db2 SQL script. This will produce 3 Postgres SQL scripts:
before.sqlcontains orders that must be run before importing data
after.sqlcontains orders that must be run after importing data
unsure.sqlcontains everything the could not be transformed automatically
3- Run the
before.sql script on PosgreSQL.
4- Extract the data from db2 with something like
/path/to/db2 -f export.db2
5- Load the data into PostgreSQL with
deltocopy -d my_output_dir | psql -e --set=ON_ERROR_STOP=1 my_new_database
6- Run the
after.sql script on PosgreSQL
7- Run the
unsure.sql script on PosgreSQL. Watch it fail and fix the statements that could not be translated automatically.
8- Launch a
VACUUM ANALYZE and enjoy your new PostgreSQL database :)
This is of course a basic tutorial. There’s a bunch of options and parallel modes. Please read the README file for more details.
Last year, Marc wrote a SQL Server to PostgreSQL Migration kit. Together with Gilles Darold (author of ora2pg an Oracle/MySQL Migration tool), they’re now on a personal quest to liberate the DBA of the world from proprietary databases :)
As always this tool is free software. If you use it, please send us feedback and new ideas on the Github page : https://github.com/dalibo/db2topg
blog comments powered by Disqus