Unanswered: Sequencing the Flow of Data in Replication
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.