Abstract :
Nowadays, there are many tools which can be used for data migration between databases. The methods of data migration which used by these tools, is well established. However, few of these tools have implemented the procedure migration. This means that the only way for users to migrate procedures in the database, is to manually modify procedures in the source database. And adapt these procedures to the target database. Thus, users have to do amounts of work, in order to migrate procedures and at the same time, users need to be very familiar with all the grammar of procedures both in the source database and target database, which is another challenge for users. In order to solve this problem, this article proposed a new tool PMT. This tool can migrate the procedure from oracle to postgreSQL without manually change. And this article also introduced the principle of PMT implementation and entire architecture of this tool. In addition to that, this article also illustrates some differences between the procedure in oracle and postgreSQL.
