pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmigrating oracle table to PostgresQL
5+ messages / 5 participants
[nested] [flat]
* migrating oracle table to PostgresQL
@ 2005-12-28 14:34 Murugan G <murugan.g@renaissance-it.com>
2005-12-28 15:12 ` Re: migrating oracle table to PostgresQL Bradley Kieser <brad@kieser.net>
0 siblings, 1 reply; 5+ messages in thread
From: Murugan G @ 2005-12-28 14:34 UTC (permalink / raw)
To: pgsql-admin
Hello,
I have some tables containing clob, blob, and long columns in Oracle, Is it possible to migrate these tables into PostgresQL along with data
Thanks and regards,
G.Murugan,
Sr. Software Engineer.
Extn. 1658
===========================================================================
Sobha Renaissance Information Technology Private Limited
An SEI-CMM & P-CMM Level 5 Company
World's 1st SSE-CMM Level 5 Company
BS 7799 certified by British Standards Institute
ISO 9001:2000 Certified by TÜV Rheinland/Berlin-Brandenburg
A Six Sigma Practice Company
Tel: + 91 80 51951999; Fax: + 91 80 51523300; Video Conference: + 91 80 51252222
Email : murugan.g@renaissance-it.com; Web: www.renaissance-it.com
===========================================================================
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete all copies from any computer.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: migrating oracle table to PostgresQL
2005-12-28 14:34 migrating oracle table to PostgresQL Murugan G <murugan.g@renaissance-it.com>
@ 2005-12-28 15:12 ` Bradley Kieser <brad@kieser.net>
0 siblings, 0 replies; 5+ messages in thread
From: Bradley Kieser @ 2005-12-28 15:12 UTC (permalink / raw)
To: Murugan G <murugan.g@renaissance-it.com>; +Cc: pgsql-admin
Yes.
But Oracle is completely useless at dumping data. You may want to use
the sqltool in HSQLDB (http://hsqldb.org/) or similar that is able to
connect both to Oracle and PG.
PLSQL developer is also able to do a connection to both but is
commercial software.
Alternatively, if you are really adventurous, set up a JDBC link to the
PG table via DBLINK in Oracle and then pump across that way.
Murugan G wrote:
> Hello,
> I have some tables containing clob, blob, and long columns in Oracle,
> Is it possible to migrate these tables into PostgresQL along with data
>
> Thanks and regards,
> G.Murugan,
> Sr. Software Engineer.
> Extn. 1658
> ===========================================================================
> Sobha Renaissance Information Technology Private Limited
> An SEI-CMM & P-CMM Level 5 Company
> World's 1^st SSE-CMM Level 5 Company
> BS 7799 certified by British Standards Institute
> ISO 9001:2000 Certified by TÜV Rheinland/Berlin-Brandenburg
> A Six Sigma Practice Company
> Tel: + 91 80 51951999; Fax: + 91 80 51523300; Video Conference: + 91
> 80 51252222
> Email : murugan.g@renaissance-it.com; Web:_ www.renaissance-it.com_
> ===========================================================================
> The information transmitted is intended only for the person or entity
> to which it is addressed and may contain confidential and/or
> privileged material. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this
> information by persons or entities other than the intended recipient
> is prohibited. If you received this in error, please contact the
> sender and delete all copies from any computer.
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: migrating oracle table to PostgresQL
@ 2005-12-28 15:26 Goulet, Dick <DGoulet@vicr.com>
2005-12-29 06:16 ` Re: migrating oracle table to PostgresQL Gourish Singbal <gourish@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Goulet, Dick @ 2005-12-28 15:26 UTC (permalink / raw)
To: Bradley Kieser <brad@kieser.net>; Murugan G <murugan.g@renaissance-it.com>; +Cc: pgsql-admin
As I browse through the contrib directory I find an Oracle directory with example perl scripts to do just as your asking.
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Bradley Kieser
Sent: Wednesday, December 28, 2005 10:12 AM
To: Murugan G
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] migrating oracle table to PostgresQL
Yes.
But Oracle is completely useless at dumping data. You may want to use
the sqltool in HSQLDB (http://hsqldb.org/) or similar that is able to
connect both to Oracle and PG.
PLSQL developer is also able to do a connection to both but is
commercial software.
Alternatively, if you are really adventurous, set up a JDBC link to the
PG table via DBLINK in Oracle and then pump across that way.
Murugan G wrote:
> Hello,
> I have some tables containing clob, blob, and long columns in Oracle,
> Is it possible to migrate these tables into PostgresQL along with data
>
> Thanks and regards,
> G.Murugan,
> Sr. Software Engineer.
> Extn. 1658
> ===========================================================================
> Sobha Renaissance Information Technology Private Limited
> An SEI-CMM & P-CMM Level 5 Company
> World's 1^st SSE-CMM Level 5 Company
> BS 7799 certified by British Standards Institute
> ISO 9001:2000 Certified by TÜV Rheinland/Berlin-Brandenburg
> A Six Sigma Practice Company
> Tel: + 91 80 51951999; Fax: + 91 80 51523300; Video Conference: + 91
> 80 51252222
> Email : murugan.g@renaissance-it.com; Web:_ www.renaissance-it.com_
> ===========================================================================
> The information transmitted is intended only for the person or entity
> to which it is addressed and may contain confidential and/or
> privileged material. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this
> information by persons or entities other than the intended recipient
> is prohibited. If you received this in error, please contact the
> sender and delete all copies from any computer.
>
>
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: migrating oracle table to PostgresQL
2005-12-28 15:26 Re: migrating oracle table to PostgresQL Goulet, Dick <DGoulet@vicr.com>
@ 2005-12-29 06:16 ` Gourish Singbal <gourish@gmail.com>
2006-01-04 00:45 ` Re: migrating oracle table to PostgresQL Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 1 reply; 5+ messages in thread
From: Gourish Singbal @ 2005-12-29 06:16 UTC (permalink / raw)
To: Goulet, Dick <DGoulet@vicr.com>; +Cc: Bradley Kieser <brad@kieser.net>; Murugan G <murugan.g@renaissance-it.com>; pgsql-admin
ora2pg tool can be used to accomplish the migration from oracle to
postgresql.
download it from here...
http://freshmeat.net/projects/ora2pg/
The one in contib directory is an old version i guess.
About clob, blob, and long columns in Oracle all become 'text' in
postgresql.
On 12/28/05, Goulet, Dick <DGoulet@vicr.com> wrote:
>
> As I browse through the contrib directory I find an Oracle directory with
> example perl scripts to do just as your asking.
>
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org [mailto:
> pgsql-admin-owner@postgresql.org] On Behalf Of Bradley Kieser
> Sent: Wednesday, December 28, 2005 10:12 AM
> To: Murugan G
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] migrating oracle table to PostgresQL
>
> Yes.
> But Oracle is completely useless at dumping data. You may want to use
> the sqltool in HSQLDB (http://hsqldb.org/) or similar that is able to
> connect both to Oracle and PG.
>
> PLSQL developer is also able to do a connection to both but is
> commercial software.
>
> Alternatively, if you are really adventurous, set up a JDBC link to the
> PG table via DBLINK in Oracle and then pump across that way.
>
> Murugan G wrote:
>
> > Hello,
> > I have some tables containing clob, blob, and long columns in Oracle,
> > Is it possible to migrate these tables into PostgresQL along with data
> >
> > Thanks and regards,
> > G.Murugan,
> > Sr. Software Engineer.
> > Extn. 1658
> >
> ===========================================================================
> > Sobha Renaissance Information Technology Private Limited
> > An SEI-CMM & P-CMM Level 5 Company
> > World's 1^st SSE-CMM Level 5 Company
> > BS 7799 certified by British Standards Institute
> > ISO 9001:2000 Certified by TÜV Rheinland/Berlin-Brandenburg
> > A Six Sigma Practice Company
> > Tel: + 91 80 51951999; Fax: + 91 80 51523300; Video Conference: + 91
> > 80 51252222
> > Email : murugan.g@renaissance-it.com; Web:_ www.renaissance-it.com_
> >
> ===========================================================================
> > The information transmitted is intended only for the person or entity
> > to which it is addressed and may contain confidential and/or
> > privileged material. Any review, retransmission, dissemination or
> > other use of, or taking of any action in reliance upon, this
> > information by persons or entities other than the intended recipient
> > is prohibited. If you received this in error, please contact the
> > sender and delete all copies from any computer.
> >
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
Best,
Gourish Singbal
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: migrating oracle table to PostgresQL
2005-12-28 15:26 Re: migrating oracle table to PostgresQL Goulet, Dick <DGoulet@vicr.com>
2005-12-29 06:16 ` Re: migrating oracle table to PostgresQL Gourish Singbal <gourish@gmail.com>
@ 2006-01-04 00:45 ` Jim C. Nasby <jnasby@pervasive.com>
0 siblings, 0 replies; 5+ messages in thread
From: Jim C. Nasby @ 2006-01-04 00:45 UTC (permalink / raw)
To: Gourish Singbal <gourish@gmail.com>; +Cc: Goulet, Dick <DGoulet@vicr.com>; Bradley Kieser <brad@kieser.net>; Murugan G <murugan.g@renaissance-it.com>; pgsql-admin
On Thu, Dec 29, 2005 at 11:46:51AM +0530, Gourish Singbal wrote:
> ora2pg tool can be used to accomplish the migration from oracle to
> postgresql.
> download it from here...
> http://freshmeat.net/projects/ora2pg/
>
> The one in contib directory is an old version i guess.
>
> About clob, blob, and long columns in Oracle all become 'text' in
> postgresql.
Actually, you don't want to store binary (blob) data in a text field.
Use bytea instead, though it's limited to 1GB. You can also use large
objects, which go up to 2G.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2006-01-04 00:45 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-28 14:34 migrating oracle table to PostgresQL Murugan G <murugan.g@renaissance-it.com>
2005-12-28 15:12 ` Bradley Kieser <brad@kieser.net>
2005-12-28 15:26 Re: migrating oracle table to PostgresQL Goulet, Dick <DGoulet@vicr.com>
2005-12-29 06:16 ` Gourish Singbal <gourish@gmail.com>
2006-01-04 00:45 ` Jim C. Nasby <jnasby@pervasive.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox