SQL conversion tool

Started by Sachin Srivastavaover 10 years ago6 messagesgeneral
Jump to latest
#1Sachin Srivastava
ssr.teleatlas@gmail.com

Hi,

Please inform which is the best tool for SQL conversion because I have to
migration Oracle database into PostgreSQL.

Regards,
SS

#2dinesh kumar
dineshkumar02@gmail.com
In reply to: Sachin Srivastava (#1)
Re: SQL conversion tool

On Wed, Nov 18, 2015 at 10:41 AM, Sachin Srivastava <ssr.teleatlas@gmail.com

wrote:

Hi,

Please inform which is the best tool for SQL conversion because I have to
migration Oracle database into PostgreSQL.

Pentaho is the tool you need to have a look. Also, talend works great.

You can check my blog
<http://manojadinesh.blogspot.de/2014/12/heterogeneous-database-sync.html&gt;
post for native Oracle support.

Regards,
SS

--

Regards,
Dinesh
manojadinesh.blogspot.com

#3Thomas Kellerer
spam_eater@gmx.net
In reply to: Sachin Srivastava (#1)
Re: SQL conversion tool

Sachin Srivastava schrieb am 18.11.2015 um 10:41:

Please inform which is the best tool for SQL conversion because I have to migration Oracle database into PostgreSQL.

Ora2Pg works quite well http://ora2pg.darold.net/

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#4dinesh kumar
dineshkumar02@gmail.com
In reply to: Thomas Kellerer (#3)
Re: SQL conversion tool

On Wed, Nov 18, 2015 at 11:24 AM, Thomas Kellerer <spam_eater@gmx.net>
wrote:

Sachin Srivastava schrieb am 18.11.2015 um 10:41:

Please inform which is the best tool for SQL conversion because I have

to migration Oracle database into PostgreSQL.

Ora2Pg works quite well http://ora2pg.darold.net/

+1

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--

Regards,
Dinesh
manojadinesh.blogspot.com

#5dinesh kumar
dineshkumar02@gmail.com
In reply to: dinesh kumar (#2)
Re: SQL conversion tool

On Wed, Nov 18, 2015 at 10:58 AM, dinesh kumar <dineshkumar02@gmail.com>
wrote:

On Wed, Nov 18, 2015 at 10:41 AM, Sachin Srivastava <
ssr.teleatlas@gmail.com> wrote:

Hi,

Please inform which is the best tool for SQL conversion because I have to
migration Oracle database into PostgreSQL.

Pentaho is the tool you need to have a look. Also, talend works great.

You can check my blog
<http://manojadinesh.blogspot.de/2014/12/heterogeneous-database-sync.html&gt;
post for native Oracle support.

My Bad. I thought the question is regarding the data migration. For the
data migration above tools works.

For SQL conversion, I know Ora2Pg is the tool we have.

Regards,

SS

--

Regards,
Dinesh
manojadinesh.blogspot.com

--

Regards,
Dinesh
manojadinesh.blogspot.com

#6Ran Fedida
rfedida@gmail.com
In reply to: Thomas Kellerer (#3)
Re: SQL conversion tool

From my work with it and as mentioned before Ora2Pg is highly recommended
and very powerfull tool to migration database from Oracle to PostgreSQL.

Ran Fedida.
בתאריך 18 בנוב׳ 2015 12:25,‏ "Thomas Kellerer" <spam_eater@gmx.net> כתב:

Show quoted text

Sachin Srivastava schrieb am 18.11.2015 um 10:41:

Please inform which is the best tool for SQL conversion because I have

to migration Oracle database into PostgreSQL.

Ora2Pg works quite well http://ora2pg.darold.net/

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general