[GENERAL] Oracle to Postgres migration open source tool
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 Regards
Re: [GENERAL] Oracle to Postgres migration open source tool
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. Numerous companies offer consulting services for PostgreSQL, some of which will cover Oracle migrations/conversions. See: http://www.postgresql.org/support/professional_support As for specific oracle to PostgreSQL migration tools: Tried Google yet? -- Craig Ringer POST Newspapers 276 Onslow Rd, Shenton Park Ph: 08 9381 3088 Fax: 08 9388 2258 ABN: 50 008 917 717 http://www.postnewspapers.com.au/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Oracle to Postgres migration open source tool
Good truth migration between Oracle and PostgreSQL are not things difficult: Indicates that your database has: Tables: 20 Shema:? functions:? Views:? They need help to migrate ... Or what are you suggestions if you need a tool that already does this task for you good people have a tool interprisedb postgres'm not recommending eye but no way they already have. : s El jue, 07-07-2011 a las 09:55 -0400, akp geek escribió: We have 20 tables in oracles that we needed to get to postgres -- __ Ing. Cesar A. Sulbaran P. Junior Web Developer. (RUBY AND RUBY ON RAILS) User 100% Open Sources. Postgresql dba. Kernel: 2.6.32-5--bigmen http://www.google.com/profiles/cesulbaran -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Oracle to Postgres migration open source tool
On Thu, Jul 07, 2011 at 09:55:45AM -0400, 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 I have used ora2pg. It was not seamless -- I had to do some whacking around of the produced files, and I had a pretty good idea of what changes were needed in the ora2pg tool to improve things, but I didn't have time to implement them. It was still a lot easier than trying to do it all by hand. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Oracle to Postgres migration open source tool
Hello, I do no have any experience with oracle, try to dump the oracle database in plain format and then try to execute the DDL and DML statements. It might be cumbersome to fix all the errors you might get. But as an initial solution give it a shot. Regards From: casp cesulba...@gmail.com To: pgsql-general@postgresql.org Cc: cesulba...@gmail.com Sent: Thu, July 7, 2011 4:05:32 PM Subject: Re: [GENERAL] Oracle to Postgres migration open source tool Good truth migration between Oracle and PostgreSQL are not things difficult: Indicates that your database has: Tables: 20 Shema:? functions:? Views:? They need help to migrate ... Or what are you suggestions if you need a tool that already does this task for you good people have a tool interprisedb postgres'm not recommending eye but no way they already have. : s El jue, 07-07-2011 a las 09:55 -0400, akp geek escribió: We have 20 tables in oracles that we needed to get to postgres -- __ Ing. Cesar A. Sulbaran P. Junior Web Developer. (RUBY AND RUBY ON RAILS) User 100% Open Sources. Postgresql dba. Kernel: 2.6.32-5--bigmen http://www.google.com/profiles/cesulbaran -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Oracle to Postgres migration open source tool
On 07/07/2011 15:21, salah jubeh wrote: Hello, I do no have any experience with oracle, try to dump the oracle database in plain format and then try to execute the DDL and DML statements. It might be cumbersome to fix all the errors you might get. But as an initial solution give it a shot. I have migrated mysql, oracle, ingres and SqlSvr databases to Postgres and in pretty much all cases around 30% of the activity has been application specific code changes or replacing Oracle or SS7 specific optimisations with pg equivalents. An example is the insert then update order issue on a unique keyed table. The order does make a differenet in processing time and if within a stored procedure I often find the procedure has to be redone to ensure it performs as expected. Things like this tend to be missed by automated Ora-Pg toolsets. I have never used the commercial Oracle portability layers but have heard good things about them. If you have no procedural code or triggers then migration is usually a few days application review work... Jacqui -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Oracle to Postgres migration open source tool
--- On Thu, 7/7/11, Craig Ringer cr...@postnewspapers.com.au wrote: From: Craig Ringer cr...@postnewspapers.com.au Subject: Re: [GENERAL] Oracle to Postgres migration open source tool To: akp geek akpg...@gmail.com Cc: pgsql-general pgsql-general@postgresql.org Date: Thursday, July 7, 2011, 2:02 PM 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. Numerous companies offer consulting services for PostgreSQL, some of which will cover Oracle migrations/conversions. See: http://www.postgresql.org/support/professional_support As for specific oracle to PostgreSQL migration tools: Tried Google yet? -- Craig Ringer POST Newspapers 276 Onslow Rd, Shenton Park Ph: 08 9381 3088 Fax: 08 9388 2258 ABN: 50 008 917 717 http://www.postnewspapers.com.au/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general i have used ora2pg migrate oracle database to postgresql http://pgfoundry.org/projects/ora2pg
Re: [GENERAL] Oracle to Postgres migration open source tool
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 Writing /export/home/postgres/perl_5_10_0/lib/perl5/site_perl/5.10.0/sun4-solaris/auto/Ora2Pg/.packlist sh install_all.sh install_all.sh: test: argument expected gmake: *** [install_all] Error 1 Thanks again Regards On Thu, Jul 7, 2011 at 11:51 AM, Lennin Caro lennin.c...@yahoo.com wrote: --- On *Thu, 7/7/11, Craig Ringer cr...@postnewspapers.com.au* wrote: From: Craig Ringer cr...@postnewspapers.com.au Subject: Re: [GENERAL] Oracle to Postgres migration open source tool To: akp geek akpg...@gmail.com Cc: pgsql-general pgsql-general@postgresql.org Date: Thursday, July 7, 2011, 2:02 PM 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. Numerous companies offer consulting services for PostgreSQL, some of which will cover Oracle migrations/conversions. See: http://www.postgresql.org/support/professional_support As for specific oracle to PostgreSQL migration tools: Tried Google yet? -- Craig Ringer POST Newspapers 276 Onslow Rd, Shenton Park Ph: 08 9381 3088 Fax: 08 9388 2258 ABN: 50 008 917 717 http://www.postnewspapers.com.au/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.orghttp://mc/compose?to=pgsql-general@postgresql.org ) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general i have used ora2pg migrate oracle database to postgresql http://pgfoundry.org/projects/ora2pg
Re: [GENERAL] Oracle to Postgres migration open source tool
On Thu, Jul 07, 2011 at 12:01:56PM -0400, akp geek wrote: 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 Writing /export/home/postgres/perl_5_10_0/lib/perl5/site_perl/5.10.0/sun4-solaris/auto/Ora2Pg/.packlist sh install_all.sh install_all.sh: test: argument expected gmake: *** [install_all] Error 1 It tries to test using a bunch of Oracle modules, and those modules install with some sort of fake dependency (ISTR it was $ORACLE_HOME, but it's a dim memory now -- there was something about installing client-only libraries IIRC). So you have to bodge up your environment to get the Perl modules installed, then you need to _re_-bodge to make sure you're actually pointing at the actual Oracle installation you want to use. A -- Andrew Sullivan a...@crankycanuck.ca -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general