Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-22 Thread Josh Harrison
On Jan 18, 2008 4:14 AM, Dorren <[EMAIL PROTECTED]> wrote: > Terabytes of data: this is a lot of Oracle data to migrate. You would > need a high performance tools capable to handle heterogeneous > environment > People suggested links here, so I will add some that could be very > appropriate to you

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-20 Thread Dorren
Terabytes of data: this is a lot of Oracle data to migrate. You would need a high performance tools capable to handle heterogeneous environment People suggested links here, so I will add some that could be very appropriate to your case: PostgreSQL loader is limited by the way. For instance, if you

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-18 Thread Josh Harrison
On Jan 18, 2008 7:45 AM, Gregory Williamson < [EMAIL PROTECTED]> wrote: > Mayuresh Nirhali wrote: > > > > Josh Harrison wrote: > > > > > > > > > Thanks . > > > We have around 3TB of data now running in Oracle. I have done > > > replication in postgresql but not much in Oracle. Is there a way you

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-18 Thread Gregory Williamson
Mayuresh Nirhali wrote: > > Josh Harrison wrote: > > > > > > Thanks . > > We have around 3TB of data now running in Oracle. I have done > > replication in postgresql but not much in Oracle. Is there a way you > > can replicate between Oracle and Postgresql. For writing the custom > > codes do

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-18 Thread Mayuresh Nirhali
Josh Harrison wrote: Thanks . We have around 3TB of data now running in Oracle. I have done replication in postgresql but not much in Oracle. Is there a way you can replicate between Oracle and Postgresql. For writing the custom codes do you suggest any preferred language ...like java, perl

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-16 Thread Josh Harrison
On Jan 16, 2008 1:31 PM, Dawid Kuroczko <[EMAIL PROTECTED]> wrote: > On Jan 11, 2008 7:14 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > > > > On Jan 11, 2008 12:02 PM, Josh Harrison <[EMAIL PROTECTED]> wrote: > > > Hi > > > We have an Oracle production database with some terbytes of data. We > w

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-16 Thread Josh Harrison
On Jan 16, 2008 1:43 PM, Josh Harrison <[EMAIL PROTECTED]> wrote: > > > On Jan 16, 2008 10:11 AM, Josh Harrison <[EMAIL PROTECTED]> wrote: > > > > > > > On Jan 15, 2008 3:58 PM, David Fetter <[EMAIL PROTECTED]> wrote: > > > > > On Mon, Jan 14, 2008 at 11:42:50AM -0500, Josh Harrison wrote: > > > >

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-16 Thread Josh Harrison
On Jan 16, 2008 10:11 AM, Josh Harrison <[EMAIL PROTECTED]> wrote: > > > On Jan 15, 2008 3:58 PM, David Fetter <[EMAIL PROTECTED]> wrote: > > > On Mon, Jan 14, 2008 at 11:42:50AM -0500, Josh Harrison wrote: > > > Thanks > > > > > > On Jan 12, 2008 9:19 AM, David Fetter <[EMAIL PROTECTED]> wrote: >

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-16 Thread Dawid Kuroczko
On Jan 11, 2008 7:14 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > > On Jan 11, 2008 12:02 PM, Josh Harrison <[EMAIL PROTECTED]> wrote: > > Hi > > We have an Oracle production database with some terbytes of data. We wanted > > to migrate that to Postgresql (rigt now...a test database and not > > p

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-16 Thread Josh Harrison
On Jan 15, 2008 3:58 PM, David Fetter <[EMAIL PROTECTED]> wrote: > On Mon, Jan 14, 2008 at 11:42:50AM -0500, Josh Harrison wrote: > > Thanks > > > > On Jan 12, 2008 9:19 AM, David Fetter <[EMAIL PROTECTED]> wrote: > > > > > On Fri, Jan 11, 2008 at 01:02:01PM -0500, Josh Harrison wrote: > > > > Hi

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-16 Thread Josh Harrison
> > > > > >> We have an Oracle production database with some terbytes of data. > > > >> We wanted > > > >> to migrate that to Postgresql (rigt now...a test database and not > > > >> production) database. > > > >> What are the good options to do that? > > > >> Please advise me on where to look for m

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-16 Thread Robert Treat
On Friday 11 January 2008 13:44, Josh Harrison wrote: > On Jan 11, 2008 1:22 PM, Erik Jones <[EMAIL PROTECTED]> wrote: > > On Jan 11, 2008, at 12:14 PM, Scott Marlowe wrote: > > > On Jan 11, 2008 12:02 PM, Josh Harrison <[EMAIL PROTECTED]> wrote: > > >> Hi > > >> We have an Oracle production databa

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-15 Thread David Fetter
On Mon, Jan 14, 2008 at 11:42:50AM -0500, Josh Harrison wrote: > Thanks > > On Jan 12, 2008 9:19 AM, David Fetter <[EMAIL PROTECTED]> wrote: > > > On Fri, Jan 11, 2008 at 01:02:01PM -0500, Josh Harrison wrote: > > > Hi > > > We have an Oracle production database with some terbytes of data. We > >

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-15 Thread Mayuresh Nirhali
Josh Harrison wrote: My question is abt the data migration. Im not sure how to try this with an online oracle database. We are required to run both postgres and oracle database simultaneously for a couple of months (atleast till we decide whether we are going to shut down oracle for good !!!)

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-14 Thread Josh Harrison
Thanks On Jan 12, 2008 9:19 AM, David Fetter <[EMAIL PROTECTED]> wrote: > On Fri, Jan 11, 2008 at 01:02:01PM -0500, Josh Harrison wrote: > > Hi > > We have an Oracle production database with some terbytes of data. We > > wanted to migrate that to Postgresql (rigt now...a test database and > > not

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-11 Thread Josh Harrison
On Jan 11, 2008 1:22 PM, Erik Jones <[EMAIL PROTECTED]> wrote: > > On Jan 11, 2008, at 12:14 PM, Scott Marlowe wrote: > > > On Jan 11, 2008 12:02 PM, Josh Harrison <[EMAIL PROTECTED]> wrote: > >> Hi > >> We have an Oracle production database with some terbytes of data. > >> We wanted > >> to migra

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-11 Thread Erik Jones
On Jan 11, 2008, at 12:14 PM, Scott Marlowe wrote: On Jan 11, 2008 12:02 PM, Josh Harrison <[EMAIL PROTECTED]> wrote: Hi We have an Oracle production database with some terbytes of data. We wanted to migrate that to Postgresql (rigt now...a test database and not production) database. What a

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-11 Thread Scott Marlowe
On Jan 11, 2008 12:02 PM, Josh Harrison <[EMAIL PROTECTED]> wrote: > Hi > We have an Oracle production database with some terbytes of data. We wanted > to migrate that to Postgresql (rigt now...a test database and not > production) database. > What are the good options to do that? > Please advise m

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-11 Thread Tom Hart
Josh Harrison wrote: Hi We have an Oracle production database with some terbytes of data. We wanted to migrate that to Postgresql (rigt now...a test database and not production) database. What are the good options to do that? Please advise me on where to look for more information on this topic