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.
Any advise would be appreciated.
Alex
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
