Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Initial steps in transactional replication - what physically happens? Expand / Collapse
Author
Message
Posted Monday, August 26, 2013 6:21 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 12:05 AM
Points: 18, Visits: 83
Hi,

I use transactional replication for reporting purposes. Something weird happened last week Friday. We had to recreate the transact replication due to system changes - the new fuctionality had to be implemented with it's own replication upfront before the reporting side's replication could be added. I had to go through the whole setup again - no problem because it is fairly straight forward. What happened after this was: A secondary process utilises the replicated database to feed info to a downstream service provider. This secondary process transmits any changes via a storedproc. After the replication was configured - bear in mind I marked it for re-initialization - two tables seemed to be truncated in the replicated database for a fraction of a second and re-populated thereafter. My question is thus: Does the replicated database's tables get truncated prior to the population of them on the initial replication? I would gather this much. Any assistance in this regard would be appreciated.

Regards,

Gert.

Kindest Regards,

Gert van Deventer



Kindest Regards,

Gert van Deventer

Post #1488349
Posted Tuesday, August 27, 2013 10:29 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:03 PM
Points: 2,967, Visits: 2,569
What replication does when table already exists at the subscriber is defined by you. You have options that include:
- drop and create the table and then load data
- truncate the table and load the data
- do nothing

When creating the publication, you can set these options either at the publication or the article level






Post #1489011
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse