Oracle Synchronization question

[ctyankeeinok]

I am looking for a way to synchronize selected data between two databases. I have a "home" database that consists of all of our data related to all events. We then take a copy of all the data for a specific event and load it onto another portable server. At the event site, we then use the portable server. The home database does not allow updates to the exported event during this period. After the event, we upload all of the changes back to the home server. I would like to be able to allow updates on both databases and synchronize the two. It is possible that separate events will occur at the same time, so the home database would synchronize with multiple events - however the subset of data being synchronized is different for each event (event 1, event 2). Any ideas on options? It is not feasible to go to a fully home based solution, so that is out. I don't have much to spend, so we may write it ourselves, but I'd like to know more options. Thanks for your thoughts.

 

[LKBrwnDBA]

Did you check out the fine Oracle® Database Advanced Replication Guide?



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[ctyankeeinok]

I will look into that. One more item - any connectivity between the remote database and the home database will be done over the internet at varying levels of performance.

 

[ctyankeeinok]

One more requirement - I don't want to have to implement a database change every time we have an event. Events happen year round at varying times. I would rather have a tool where we can identify the event and use the same scheme (other than the event ID) for each event as we need to replicate.

 

[LKBrwnDBA]

One more item - any connectivity between the remote database and the home database will be done over the internet at varying levels of performance.

No problem here (depending on how you configure replication).

I don't uderstand the following statement:

I don't want to have to implement a database change every time we have an event.

If by Database change you mean "schema" change, look into "streams" replication.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[ctyankeeinok]

LKBrwnDBA - You interpreted my DB change correctly - I don't want to do a schema change every time I have an event go offsite. Thanks for the tip on Streams. I'm looking into it.... Any other ideas out there are welcome as well...