Oracle XE as local recovery database and Oracle Standard as main db
Posted
by jbendahan
on Stack Overflow
See other posts from Stack Overflow
or by jbendahan
Published on 2010-04-21T14:19:48Z
Indexed on
2010/04/21
14:23 UTC
Read the original article
Hit count: 307
Hi, I just wanted to know what you guys think about this.
I have an app written in Visual Basic .Net as my front end and and Oracle 11g Standart database as the back-end. So I have like 20 pc's running this app locally. They're all inserting, updating, deleting data on this single database. I want to develop a solution in the case that the server database crashes or cannot stay on line. So i think of having oracle 10g XE on each pc. Thus all the data will be stored in the local db. I think about running a proccess once in a while (ex. every 15 minutes) to send/get the data to/from the main server. What do you think about this strategy?
© Stack Overflow or respective owner
