CODEWITHSUNDEEP
database-migrationpostgresql-9.3db2-luw
Arijit Ghosh
Arijit Ghosh

Reputation: 1

Migrate DB2 LUW 9.7 databases and data to PostgreSQL

I am trying to migrate DB2 LUW 9.7 databases and data to PostgreSQL 9.3. Any suggestion on which will be the best approach to do it? Which will be the best tool or any open source tool available to perform this?

Upvotes: 0

Views: 994

Answers (1)

Fred Sobotka
Fred Sobotka

Reputation: 5332

The db2look utility can reverse-engineer your DB2 tables into DDL statements that will serve as a good starting point for your PostgreSQL definitions. To unload the data from each table, use the EXPORT command, which dumps the results of any SQL SELECT to a delimited text file. Although the db2move utility can handle both of those tasks, is not going to be of much help to you because it extracts the table data into IBM's proprietary PC/IXF format.

If you're moving off of DB2 because of price, IBM provides a free-as-in-beer version called DB2 Express-C, which shares the same core database engine as paid editions of DB2. Express-C is a first-rate, industrial strength DBMS that does not have the sort of severe limitations that other commercial vendors impose on their no-cost engines.

Upvotes: 1

Related Questions