mirroring or merging or something else

[Igaduma]

Hello All,

I'm facing a rather nasty problem which maybe some you of you can shed some light on or just inform me to stop looking for a non-existing solution.
I have to set up a citrix environment with 1 production db and clients (application) connecting local over a lan or remotely (citrix) over a leased line setup.
No biggie.
But...
The leased line vendor has to delay the activation for 3-5 weeks (LL entry hardware is saturated and needs another board) but I really should get both offices running on the same database somehow during this unforeseen delay period.
There is no way of using VPN over internet since office A is our client (read:we must bend) and only allows traffic on port 80 through a very tight (read:duck's ass) proxy.

The interim solution would be to have office A (not many users) running their own db of a free desktop as long as the leased lines are not operational, but that means production db is split in two seperate branches which does not really help my case.at all.
Is there some sort of "merge nightly" or sync-nightly application that oracle has for this?

Is there -at all- any possible solution to this problem ?
I'm pretty ok with just regular oracle db installations and such, but I'm not sure which product I have to investigate in this case or which approach would be reasonably appropriate to even start with.

Any help is appriciated...

Iga

 

[Turkbear]

Hi,
If there is no connectivity between A and B then how would you sync or merge the data..SneakerNet?

The only solution I can see is to have an Oracle instance ( preferably - but Access can do for a short time..the tables can be exported to Oracle after) running at A and, when connection can be established load/merge that data into the matching tables at B..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Igaduma]

Hi,
The db has many sequences/triggers and such.
And yes, sneaker or mobilenet would be appriopriate here.
Long time had to support an app using "gothic oodb" which worked with branches & merges.
Real pain in the ass, but very suitable for remote offices without connectivity 'back then', although very limited, the area that was "taken out of production" was readonly & not open for updates on other branches.

I wouldn't mind driving up & down in the evening syncing things up if this would help The Cause obviously.

Iga

 

[Turkbear]

Hi,
Perhaps you can take the data from A and load it into a Holding Table(s) in B's Oracle instance..Then merge it with the relevant B table(s) - The Merge command seesm ideal for this...Assuming your Oracle is a current enough version to support the MERGE command..

See :

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_915a.htm

You may need to register for Technet..It is free, very useful and no spam from it..







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[sem]

You may also consider replication

Regards, Dima

http://seminihin.narod.ru