Re: Copying Data from Oracle to PostgreSQL

From: Pepe TD Vo <pepevo(at)yahoo(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: marcelo zen <mzen(at)itapua(dot)com(dot)uy>, Shreeyansh Dba <shreeyansh2014(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Copying Data from Oracle to PostgreSQL
Date: 2019-01-17 16:54:54
Message-ID: 74388008.1250118.1547744094605@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

this is not production server.  We need to test out on development servers before playing with a real one. Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success

On Thursday, January 17, 2019 11:52 AM, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

On Thu, Jan 17, 2019 at 9:24 AM Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:
> I don't have a 3rd server to install ora2pg to connect between two oracle and postgres db servers.  Contract is not funded to get extra server(s) and/or training.

Assuming the existing Oracle server is in production I would recommend
you not install stuff there which only leaves the new PostgreSQL
server as an option given your apparent limitations.

That's likely that last I will say on the topic - I agree with
Laurenz's sentiments; You don't seem to be in a position to personally
fulfill this contract that you've been assigned and you need to
consider how to deal with that fact.  You haven't even gotten to the
hard part yet and your hands are tied in ways they should not be
(i.e., the machine you are performing the work on, a newly created
virtual machine workstation ideally, should have internet access).

David J.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Gary Stainburn 2019-01-18 14:29:51 upgrade from FC9 / PG8.3 to C7 / PG 9.6 - utf8
Previous Message David G. Johnston 2019-01-17 16:52:35 Re: Copying Data from Oracle to PostgreSQL