Thread: Fwd: Re: [ADMIN] migrating oracle table to PostgresQL
I believe this is one of the projects that we have slated for removal, since it lives nicely elsewhere. Is it worth me writing up a patch to remove the files and update the README to provide pointers to the project site and maybe a few other places like the oraclecompat project (and maybe even enterprisedb) or does someone with commit want to just go ahead and do it? Robert Treat ---------- Forwarded Message ---------- Subject: Re: [ADMIN] migrating oracle table to PostgresQL Date: Thursday 29 December 2005 01:16 From: Gourish Singbal <gourish@gmail.com> To: "Goulet, Dick" <DGoulet@vicr.com> Cc: Bradley Kieser <brad@kieser.net>, Murugan G <murugan.g@renaissance-it.com>, pgsql-admin@postgresql.org 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 ------------------------------------------------------- -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Robert Treat wrote: > I believe this is one of the projects that we have slated for removal, since > it lives nicely elsewhere. Is it worth me writing up a patch to remove the > files and update the README to provide pointers to the project site and maybe > a few other places like the oraclecompat project (and maybe even > enterprisedb) or does someone with commit want to just go ahead and do it? We have been waiting for someone to do it for _too_ long. Please feel free to submit something. I recommend you get the list of changes from the archinves that we agreed to for /contrib and use that as a guide. I am still waiting for all valid gborg projects to be moved to pgfoundry. How many years has that been in the air? I know people have said they would complete these items, but they have had sufficient time, and it is time to bring in other people for the job. Our web site is looking great and is well organized. It is time for us to do the same for add-on projects. --------------------------------------------------------------------------- > Robert Treat > > ---------- Forwarded Message ---------- > > Subject: Re: [ADMIN] migrating oracle table to PostgresQL > Date: Thursday 29 December 2005 01:16 > From: Gourish Singbal <gourish@gmail.com> > To: "Goulet, Dick" <DGoulet@vicr.com> > Cc: Bradley Kieser <brad@kieser.net>, Murugan G > <murugan.g@renaissance-it.com>, pgsql-admin@postgresql.org > > 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 > > ------------------------------------------------------- > > > > -- > Robert Treat > Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
On Thursday 29 December 2005 21:35, Bruce Momjian wrote: > Robert Treat wrote: > > I believe this is one of the projects that we have slated for removal, > > since it lives nicely elsewhere. Is it worth me writing up a patch to > > remove the files and update the README to provide pointers to the project > > site and maybe a few other places like the oraclecompat project (and > > maybe even enterprisedb) or does someone with commit want to just go > > ahead and do it? > > We have been waiting for someone to do it for _too_ long. Please feel > free to submit something. I recommend you get the list of changes from > the archinves that we agreed to for /contrib and use that as a guide. > > I know people have said they would complete these items, but they have > had sufficient time, and it is time to bring in other people for the job. > Turns out I can't really make a patch that removes files without write access to CVS. There's some funky things you can do with diff -N and patch -E but seems like a pain. Attached is a patch that at least updates the general contrib README and Makefile, someone else will have to actually delete the files in the oracle/ directory. (If yall want to give me write access, I could spend some time cleaning up some more of these) Oh, and no special write up for the README, looking at some of the other contribs that did get removed, apparently we don't do that, but the commit should probably at least mention the project page, http://freshmeat.net/projects/ora2pg/ -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL