You are viewing a plain text version of this content. The canonical link for it is here.

Posted to torque-user@db.apache.org by "Sica, David (David)" <ds...@avaya.com> on 2004/06/09 21:50:13 UTC

Multiple Databases

Hello,

I'm currently using Torque 3.1 with a set of tables in PostgreSQL 7.4.2.
Our project is looking to replicate the data for a subset of tables into
Oracle.  Two questions:

1) What is the easiest way to setup Torque to perform duplicate
operations on 2 databases for certain tables/objects?

2) Do the tables and columns need to have the same name in PostgreSQL
and Oracle?  If not, how do I specify different table and column names
for the 2nd (Oracle) database?

Thanks,
David Sica