Thank you all for the responses. All we have is just table migrations, no procedures, triggers involved. I will try to do the migration using ora2pg. I downloaded it, while installing it I am getting an error. Will try to resolve that and proceed
On 7/07/2011 9:55 PM, akp geek wrote: > Hi all - > > Are there any open source tools available for migrating > from oracle to postgres. We have 20 tables in oracles that we needed to > get to postgres. Appreciate your help
One avenue you may wish to investigate is ETL tools like Talend. See Google.
EnterpriseDB offer an enhanced version of PostgreSQL with add-on Oracle compatibility features to ease porting. This might be worth looking into.