October 14, 2010 at 12:52 am
Dear Experts,
I have implemented the Transactinal replications with 20 tables only,
While I inserting the data from Base DB more than 1 Million records,
the subscriber database also having the inserting data with 0 latency, How its possible?
Transactional Replications: How to migrate the Data from base DB to Subscriber DB,
What i Undersrood: Every time The Subscriber Database tables truncate and Bulk insert from Base DB.. is this correct? If Correct mean..
Is that reduce the Performace of Base DB...
Please clarify me.. Because I can take some other Steps..
October 14, 2010 at 3:36 am
What i Undersrood: Every time The Subscriber Database tables truncate and Bulk insert from Base DB.. is this correct? If Correct mean..
Is that reduce the Performace of Base DB...
I'm assuming that you're asking if the data in the subscriber DB is truncated and bulk inserted from the publisher DB? Such behaviour happens if you re-initialize the snapshot and if specific article properties are set. Options for subscriber tables when a snapshot is applied and the table already exists on the subscriber are:
a) Do nothing (I think this is a valid option - need to recheck)
b) Delete - deletes data in the destination table and applies the snapshot
c) Drop (the default option) - drops the destination table and applies the snapshot (creates the table and loads data from the snapshot files)
d) Truncate - truncates the destination table and applies the snapshot
In normal operations (i.e. data changes on the publisher flowing to the subscriber) the distribution agent applies the commands to make the data changes on the susbscriber. These commands can be in the form of parameterized replication SPs or custom SPs or SQL statements. The default is to auto create an SP on the subscriber (when setting up replication) for each action (insert/update/delete) and invoke that SP.
All this information is available here
While I inserting the data from Base DB more than 1 Million records,
the subscriber database also having the inserting data with 0 latency, How its possible?
I didn't get the question - are you concerned that replication is fast?;-)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply