Application & Table Merging

From: Alan Moore <alan.moore_at_it.glasgow.gov.uk>
Date: 1997/03/04
Message-ID: <331C60DB.3B51@it.glasgow.gov.uk>#1/1

Hi all,

Could anyone possibly suggest a solution to this problem.....

My site currently has an Application residing as 4 separate Instances/UNIX boxes - representing 4 geographical areas. The database schemas are identical in every case.

A requirement has now arisen to merge the 4 Instances into one (i.e. merge data from 4 table occurences into 1 occurence), on a single UNIX platform.

The data merge is relatively straightforward - BUT !...

A User updating their subset (view) of data also requires 'read only' access to the other 3 representative areas IN THE SAME TABLE.

The intention here is to attempt a DBA solution as opposed to changing the entire Application code.

Any suggestions would be appreciated.

Thanks in advance.

Alan Moore. Received on Tue Mar 04 1997 - 00:00:00 CST