Re: Synchronization of multiple database instance at multiple sites with Workgroup Edition

By buying the Replication version of the software! Your boss wants his head examining: replacing one tool with another that lacks a major required facility is not a good idea!

You could by a third party replication tool (I believe that Quest Software has one), or
else you have to write your own replication routines.

In the latter case, you probably need to create a 4th DB, that compares the data on
the three other databases, table by table, and creates a composite database. Then
that composite database needs to be dowbloaded to your other three sites.

Your are best off writing DB packages/procedures to do this.

Unless your setup is simple, then this could be a nightmare to write and maintain.

Alternatively, if your databases are query intensive, you could write your application
to query the local database, but only update the central one (over a WAN). This would make things simpler, while giving performance gains. However, you would need a permanent WAN line in place between the 'master' and 'slave' databases.

If you have to do this, then (if the databases are lightly used) dispense with the
local databases altogether, and simply have a central DB with a WAN connection
to the local sites.

You are strongly advised to go for a professions replication tool.

Simon Hedges
Gloucester
UK

Shawn Tee <ystee_at_mbox4.singnet.com.sg> wrote in message news:7j7rgb$3bn$1_at_news5.jaring.my...
> Hi,
>
> My company has just migrated from MSsql 6.5 to Oracle. We have 3 site
> offices and will be installing an Oracle database engine at each of the
> site. Since my boss has bought the Workgroup Edition(without
replication),
> can anyone provide any idea on how can I synchronized the 3 database
> instances at the end of a transaction day.
>
> Thanks.
>
> sucheeha_at_singnet.com.sg
Received on Fri Jun 04 1999 - 14:30:14 CEST