Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database replication
I don't know DB2.
I've juste worked with Oracle multi-master Replication option. I think it's
suitable for your 2000-rows-journally-transactions.
It's quite easy to make the configuration of the two servers (in one day).
hth
yang
dba oracle.
"Michael Wimmer" <newsgroup1_at_ecom.at> a écrit dans le message de news:
41c190d9$0$25184$91cee783_at_newsreader01.highway.telekom.at...
> Hi,
>
> I need some advice on database replication.
>
> A customer wants his databases replicated between two servers, connected
> by the internet. The database structure will be quite simple, mainly
> address data with about 100.000 entries in the beginning, but steadily
> increasing.
>
> We expect an average of up to 2000 new inserts or edits per day.
>
> The customer wants the data to be stored in both databases, so querying
> one database from the other is not an option.
>
> A perfect solution would allow both database servers to change data and
> insert new records, but this could be discussed if it would make things
> much more complicated.
>
> As a database Oracle and DB2 are into consideration so I am happy with
> advice on both systems. Maybe someone can give me a hint which of these
> two would be more suited for the task.
>
> Any help / advice highly appreciated
>
> best regards
>
> Michael
>
Received on Thu Dec 16 2004 - 14:13:02 CST