Re: [GENERAL] Mirroring tables from Oracle to Postgresql

2004-04-21 Thread Jan Wieck
Andrew Rawnsley wrote: The java code is reasonably agnostic, provided the JDBC driver is smart enough to deal with any datatype properly as strings, although that intelligence can be added. Something else as a slave would be considerable easier, of course. For something else to be the master, y

Re: [GENERAL] Mirroring tables from Oracle to Postgresql

2004-04-16 Thread Andrew Rawnsley
The java code is reasonably agnostic, provided the JDBC driver is smart enough to deal with any datatype properly as strings, although that intelligence can be added. Something else as a slave would be considerable easier, of course. For something else to be the master, you would have to find a

Re: [GENERAL] Mirroring tables from Oracle to Postgresql

2004-04-16 Thread Andrew Sullivan
On Mon, Apr 05, 2004 at 03:58:36PM +0200, Miguel Guzman Miranda wrote: > I've been suggested to do a triggered procedure in Oracle so that > everytime a file is inserted, deleted or updated, a perl script is run > which modifies in turn the PSQL DB. If you go to gborg and get the latest erse

Re: [GENERAL] Mirroring tables from Oracle to Postgresql

2004-04-05 Thread Cees van de Griend
Hello Miguel, On Monday 05 April 2004 15:58, Miguel Guzman Miranda wrote: > My issue is that I need to do some replication from Oracle tables to > PSQL. One-way only, incremental, and to a remote machine. I have to replicate a lot of data from Oracle/MS SQL/Progress to PostgreSQL I have wri

[GENERAL] Mirroring tables from Oracle to Postgresql

2004-04-05 Thread Miguel Guzman Miranda
Hi there, First of all, I suppose my problem should be at least farly common, but haven't had luck trying to find what I need by searching on the docs, google, etc. So please if this issue has already been covered please point me to some URL, or the list archives, or what you think is fine