Compare, Merge and replicate between Oracle and MS Access

Hi DBAs, I am researching for solution for a new project. We have a few tables in Oracle8i db, similar tables with more columns and more data in MS Access. The data is very static. Our plan is to synchronize the two dbs, from then on we will always put change(adding more columns, or insert new

RE: Compare, Merge and replicate between Oracle and MS Access

Are you serious? Replication between Oracle and MS Access, why? -Original Message- Sent: Friday, February 22, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Hi DBAs, I am researching for solution for a new project. We have a few tables in Oracle8i db, similar tables with more

RE: Compare, Merge and replicate between Oracle and MS Access

James - Have you considered just maintaining the Oracle tables and then attaching (or whatever the Access word is) the Oracle table in Access? That way you have a single table, single source, etc. Simple is good. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message-

RE: Compare, Merge and replicate between Oracle and MS Access

James can you tell us more about the requirements of your environment/software that would cause such a solution to arise. I can see the possibility of writing a MS Access client that perhaps your sales staff uses that replicates with the database. Hopefully, you don't have too many tables. You

RE: Compare, Merge and replicate between Oracle and MS Access

from Oracle to MS Access in batch process, but we want to automate the process. -Original Message- From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 2:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Compare, Merge and replicate between Oracle

RE: Compare, Merge and replicate between Oracle and MS Access

recipients of list ORACLE-L Subject: RE: Compare, Merge and replicate between Oracle and MS Access Are you serious? Replication between Oracle and MS Access, why? -Original Message- Sent: Friday, February 22, 2002 2:09 PM To: Multiple recipients of list ORACLE-L -- Please

RE: Compare, Merge and replicate between Oracle and MS Access

I am wondering what the license issues with this would be. - E -Original Message- Sent: Friday, February 22, 2002 1:49 PM To: Multiple recipients of list ORACLE-L James - Have you considered just maintaining the Oracle tables and then attaching (or whatever the Access word is) the

RE: Compare, Merge and replicate between Oracle and MS Access

Can you not substitute say, Oracle Lite for Access on the 'downstream' sites use Oracle's native replication? (Or keep Access as a front-end, but use OL for the actual storage the replication.) I would guess you'd be in for less work/trouble that way (tho I know zip about Oracle's replication

RE: Compare, Merge and replicate between Oracle and MS Access

To: Multiple recipients of list ORACLE-L Subject: RE: Compare, Merge and replicate between Oracle and MS Access James - Have you considered just maintaining the Oracle tables and then attaching (or whatever the Access word is) the Oracle table in Access? That way you have a single

RE: Compare, Merge and replicate between Oracle and MS Access

Subject: RE: Compare, Merge and replicate between Oracle and MS Access Are you serious? Replication between Oracle and MS Access, why? -Original Message- Sent: Friday, February 22, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Hi DBAs, I am researching