Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Future of "Logical Records" in SQL Merge Replication

I am building a new application which will be using SQL Merge Replication over very poor networks. It appears that the "Logical Records" feature would help significantly in coping with these network problems, ensuring that we can get complete 'entities' replicated one by one in separate transactions rather than going table by table.

However, the documentation states

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

What I can't find in the documentation is a recommendation for what should be used instead to get similar functionality. Does such a recommendation exist? If not an official recommendation, what have people come up with on their own?

like image 237
Robert Levy Avatar asked Nov 05 '22 18:11

Robert Levy


1 Answers

The following quote was marked as correct by Microsoft Tech Support on the same question at msdn.

"... only the concept of Logical records is being deprecated.  
We can still define relationships using sp_addmergefilter @filter_type=1 ..."

If you read through the documentation of sp_addmergefilter it does appear you can accomplish the same purpose of the deprecated feature using a join filter @filter_type=1 (as opposed to the deprecated @filter_type=2).

like image 132
RThomas Avatar answered Nov 15 '22 13:11

RThomas