Unanswered: Problem in Intialization ofTransactional Replication
I have created a transactional replication with publisher in server1 and subscriber in server2. My requirement is to create 1 publisher and multiple subscribers for that publisher. Assume that there is one Sales Office-Regional and multiple sales office at different locations. So, i resembled this with 1 publisher and multiple subsribers. Now after the publisher and subscriber , i have created the snapshot as welll.
Once i initialize the subscription i would like to insert only data which belongs to the sales_org_Id already defined i the subscriber. I wouldnt like to insert data that doesnt belong to that sales org id. HOW DO I DO THIS?. Because during initialization only BCP commands are fired and im not able to filter based on the sales org id. Could anybody help me on this issue?