Support in SQL Server for custom COM-based conflict resolvers that handle merge replication

Applies to: Microsoft SQL Server 2005 Developer EditionMicrosoft SQL Server 2005 Enterprise EditionMicrosoft SQL Server 2005 Enterprise X64 Edition More

Summary

Microsoft COM-based resolvers handle update, insert, and delete conflicts in the following versions of Microsoft SQL Server:
  • Microsoft SQL Server 2005
  • Microsoft SQL Server 2008
  •  Microsoft SQL Server 2008 R2
  • Microsoft SQL Server 2012
The article discusses support for custom COM-based conflict resolvers for merge replication when those resolvers are built by using Microsoft .NET-managed assemblies. Such COM-based conflict resolvers for merge replication interact with the replication interfaces for native COM in SQL Server.

More Information

It was not a design objective in SQL Server to support custom COM-based conflict resolvers that interact with replication interfaces for native COM when those resolvers are built by using managed .NET assemblies. Therefore, Microsoft does not support these COM-based conflict resolvers.

Merge replication in SQL Server provides an API to build native COM resolvers. You can build native COM-based replication resolvers as COM objects in languages such as Microsoft Visual C++ and Microsoft Visual Basic.

Note We recommend that you build the managed code assemblies by using the business logic handler framework in SQL Server. The business logic handler framework contains the business logic that can respond to conflicts and other conditions during the merge replication process.

References

For more information about how to implement a business logic handler, visit the following MSDN website:
http://msdn.microsoft.com/en-us/library/ms152573.aspx
For more information about COM-based resolvers, visit the following MSDN website:
http://msdn.microsoft.com/en-us/library/ms152573.aspx