December 17, 2014 at 11:14 pm
Hi,
If i want to replicate data only for a particular customer code using SQL 2012 replication - is it possible. I believe that either the entire database or few tables can be replicated using SQL 2012.
Thanks,
Regards,
Ami
December 18, 2014 at 1:24 am
You could edit the Stored Procs on the Subscriber to check for the correct conditions before procedding the data. Depending upon how many tables and how you identify the data this could be quite a bit of work. Another downside of this is that all of the data for the tables is still read by the Distributor and sent to the Subscriber but isn't actually required.
December 19, 2014 at 4:26 am
right click on your publication.. go to Filter rows and add a filter for that specific code
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply