Re: Help required for Data replication from local to central database

Binay Pandey wrote:

> Hi,
>
> We have a requirement where daily transactions will be held at
> local databases located at different centres having same set of tables
> and at the end of the day INCREMENTAL data from all centres needs to
> be merged at central server. So Central server will be a superset of
> all the centres data.
>
> Here all the transactions will be done at local database level only.
> In central databse we want the complete organisations data for
> reporting purpose.
>
> A dedicated link of central database with the local databases may not
> be available all the time because of network bottlenecks.
>
> Can any one guide me on the approach which is best suited for this
> scenario.
>
> Regards
> Binay

Use advanced replication with updatable snapshots on the local databases. Received on Wed Jan 09 2002 - 00:02:49 CST