Sequencing the Flow of Data in Replication

• Balaji Krishnamoorthy-415222

  SSC Enthusiast

  Points: 166

  More actions

  October 22, 2008 at 11:02 pm

  #195049

  Hi All,

  I am going to implement 1 publisher with multiple subsriber model in transactional replication. I use push subscription option. While i replicate the data i want to define the order of flow of data between various tables.For example, the following tables are included in publication and i want the order of data flow as follows,

  1. Dept ( This is table with Dept_ID as primary key)

  2. Employees ( This table has DeptID as foreign key)

  So, i want to make sure that all Dept datas are replicated before replicating the Employee tabble records.

  Any inputs would be of much help...

  Thanks

  Balaji

• Kendal Van Dyke

  SSCertifiable

  Points: 5972

  More actions

  October 23, 2008 at 8:56 am

  #888657

  Changes to subscribers are made in the same order that they are first applied at the publisher.

  Kendal Van Dyke
  http://kendalvandyke.blogspot.com/[/url]