Re: Fast Table Replication / Mirroring

I need to reflect the changes onto the secondary machine and would like
to initiate and run the process from the primary machine. The secondary
machine may be in use at the time (read only though) and I cannot
truncate or drop tables there (also because I have foreign key
constraints on the table itself).

Ron Johnson wrote:

>On Thu, 2003-08-28 at 22:49, Alex wrote:
>
>
>>Hi,
>>I saw some replication projects but think this might be an overkill for
>>my intentions.
>>
>>I have two databases, Primary / Secondary where the Secondary is
>>readyonly for
>>users. I need to mirror tables when changes occur on that table. That
>>may happen a few times a day.
>>Tables are in the area of few 100k records.
>>
>>A) Is there an easy way to copy the data from Primary to Secondary
>> Can this be triggered by updates on the primary table ?
>>
>>B) Is there a fast way to check if table A on Primary and Secondary
>>server are in Sync?
>> Not number of records but contents.
>>
>>
>
>If changes only happens a couple of times a day, and the table only
>have a few hundred thousand rows in them, why not dump the tables
>every few hours and load them into the Secondary DB?
>
>
>