-
Notifications
You must be signed in to change notification settings - Fork 11
Home
In an Oracle to PostgreSQL project, the database has to be migrated. Many tools can help you in this task (with ora2pg
being the most well known one) and will migrate your data and most objects in your database.
But your application code may also have specific Oracle instructions and those need to be translated too. code2pg
is here to help by estimating in man-days how difficult such a migration is and by telling you where Oracle instructions were identified.
There is a little reference to the excellent ora2pg
tool.
You need a Perl distribution and the possibility of installing a few extra packages. This should be trivial on RHEL/Centos, Debian distributions. Bear in mind that it is only very lightly tested on Windows.
A command line help is available by launching ./code2pg --help
. The full documentation is available here.
Automatic translation is a very difficult subject in its own. What makes it even more difficult here is the presence of dynamic sql that can be generated in your application code. This will require implementing a proper parser and a huge number of rules. Such a work will not be done in the near future.
No software is perfect and code2pg
does not have such ambitions. If something is not working as documented, if you notice a bug or wish to add new features, do not hesitate to fill issues or make pull requests.