Question

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?

Answer 1

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).

友情链接