Re: [GENERAL] [SQL] PostgreSQL to Oracle

2007-03-16 Thread Jonah H. Harris
On 3/16/07, David Fetter <[EMAIL PROTECTED]> wrote: DBI-Link has a way to push predicates to the remote side, ... As Ezequias asked about migrating an application, I'm not quite sure why we're discussing this. Using HSODBC to move data permanently is quite good assuming you have no data type

Re: [GENERAL] [SQL] PostgreSQL to Oracle

2007-03-16 Thread David Fetter
On Fri, Mar 16, 2007 at 10:18:56AM -0700, Reece Hart wrote: > On Thu, 2007-03-15 at 16:20 -0400, Robert Treat wrote: > > Do you find [HSODBC] works well? I've used it from some older > > Oracle instances connecting back into PostgreSQL and the results I > > had have been flakey at best. > > - The

Re: [GENERAL] [SQL] PostgreSQL to Oracle

2007-03-16 Thread Reece Hart
On Thu, 2007-03-15 at 16:20 -0400, Robert Treat wrote: > Do you find [HSODBC] works well? I've used it from some older Oracle > instances connecting back into PostgreSQL and the results I had have > been flakey at best. For us too. We tried in early 2006 with Oracle 8 via hsodbc to postgresql 7.4

Re: [GENERAL] [SQL] PostgreSQL to Oracle

2007-03-15 Thread Jonah H. Harris
On 3/15/07, Robert Treat <[EMAIL PROTECTED]> wrote: Do you find this works well? I've used it from some older Oracle instances connecting back into PostgreSQL and the results I had have been flakey at best. It really just depends on the data types in use... but I've never really had anything I

Re: [GENERAL] [SQL] PostgreSQL to Oracle

2007-03-15 Thread Robert Treat
On Friday 09 March 2007 13:32, Jonah H. Harris wrote: > To copy the data and table definitions, I'd use a database link (on > the Oracle side) with hsodbc connecting to your PostgreSQL system via > ODBC. > Do you find this works well? I've used it from some older Oracle instances connecting back

Re: [GENERAL] [SQL] PostgreSQL to Oracle

2007-03-09 Thread Ezequias Rodrigues da Rocha
Thank you Jonah, That isn't a decision taken but I will need to argue with the new team of my new company. I can't see why but I will see how the things occurs. Thank you again Ezequias 2007/3/9, Jonah H. Harris <[EMAIL PROTECTED]>: On 3/9/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wr

Re: [GENERAL] [SQL] PostgreSQL to Oracle

2007-03-09 Thread Jonah H. Harris
On 3/9/07, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote: Is it a simple action to convert a database from PostgreSQL to Oracle ? Yes, relatively. Has someone any idea ? There's a couple ways to do this, but I'd recommend first using pg_dump to export schema only. Your functions an