Database Migration From Oracle To Postgres

In the past, many companies stored their data in Oracle database, the most populardatabase at that time, because of their business considerations. However, as the company’sbusiness developed, they have reconsidered their business in many aspects, such as thedeveloping cost, the developing and the maintenance of database. Therefore, they want tomigrate the data from oracle to PostgreSQL, which is free and open source database and hasgradually improved performance. Thus, this article proposed an efficient way to migrateOracle database to PostgreSQL database.This article illustrates the process of migration from Oracle database to PostgreSQLdatabase in three aspects. These aspects include table structure migration, data migration andprocedure migration. Table structure migration is mainly for migrating the table in Oracledatabase and the constraints related to that table to the corresponding tablespace inPostgreSQL database. Data Migration is mainly for migrating data stored in Oracle databaseto the corresponding tables in PostgreSQL database. This article demonstrates a technique fordata migration. This technique spent half of the time to migrate large number of table,compared to ESF, which is considered as the fastest migration tool by now. Proceduremigration is mainly migrate the procedures in Oracle database to PostgreSQL database.Nowadays there is no mature migration tool which can implement procedure migration.At the meantime, this paper put forward a series of valuable evaluation methods andperformance indexes, to compare the performance of different migration tools. And we did a lot of experiments to compare the performance of these tools by these methods. After that, wethoroughly analyzed the result of these experiments in this article.