Skip to content

Latest commit

 

History

History
80 lines (52 loc) · 6.2 KB

debug-a-business-logic-handler-replication-programming.md

File metadata and controls

80 lines (52 loc) · 6.2 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom helpviewer_keywords dev_langs
Debug business logic handler (Replication Programming)
Learn how to use a business logic handler to invoke custom business logic when a Merge Subscription is synchronized.
MashaMSFT
mathoma
09/25/2024
sql
replication
how-to
updatefrequency5
merge replication business logic handlers [SQL Server replication]
business logic handlers [SQL Server replication]
BusinessLogicModule class
VB
CSharp

Debug a Business Logic Handler (Replication Programming)

[!INCLUDE SQL Server] Use a business logic handler to invoke custom business logic when a merge subscription is synchronized. For more information, see Execute Business Logic During Merge Synchronization.

The Merge Replication Reconciler (replrec.dll) calls the managed code assembly containing the business logic. In most cases, replrec.dll and the custom business logic is executed on the computer where the Merge Agent runs (at the Subscriber for a pull subscription or at the Distributor for a push subscription). In the case of Web synchronization, or in the case of a [!INCLUDEssEW] Subscriber, the reconciler and the custom business logic is executed on the Web server.

To debug a business logic handler on a local computer

  1. Configure publishing and distribution, create a publication, and create a subscription to the publication. For more information, see Configure Publishing and Distribution and Create a Publication.

  2. Create and register a business logic handler. For more information, see Implement a Business Logic Handler for a Merge Article.

  3. Create a Replication Management Objects (RMO) project in [!INCLUDEmsCoName] Visual Studio that programmatically starts the Merge Agent synchronously. For more information, see Synchronize a Pull Subscription.

  4. Set a breakpoint in the business logic handler code, either in the method being debugged or in the class constructor. For more information about the methods that can be implemented in a business logic handler, see the xref:Microsoft.SqlServer.Replication.BusinessLogicSupport.BusinessLogicModule methods topic.

  5. Build the business logic handler in debug mode and deploy the assembly and debugging symbol file (.pdb) in the location registered in step 1.

    [!NOTE]
    To simplify debugging, create a single Visual Studio .NET solution that contains both the business logic handler project and the project that synchronizes the subscription. In this case, set the synchronization project as the startup project, and configure the build environment to deploy the business logic assembly to the location registered in step 1 during debugging.

  6. Execute insert, update, or delete commands against the subscription or publication database. The command and execution location depends on the method being debugged.

  7. Start the project from step 3 in debug mode to synchronize the subscription.

  8. Assuming that no other breakpoints are set and the proper commands are replicated, the execution stops when it reaches the breakpoint in the business logic handler.

To debug a business logic handler on a Web server using Web synchronization, or for a SQL Server Compact Subscriber

  1. Configure publishing and distribution, create a publication, and create a pull subscription to the publication. The publication must support Web synchronization or [!INCLUDEssEW] Subscribers.

  2. Create and register a business logic handler. For more information, see Implement a Business Logic Handler for a Merge Article.

  3. Set a breakpoint in the business logic handler code, either in the method being debugged or in the class constructor. For more information about the methods that can be implemented in a business logic handler, see the xref:Microsoft.SqlServer.Replication.BusinessLogicSupport.BusinessLogicModule methods topic.

  4. Build the business logic handler in debug mode and deploy the assembly and debugging symbol file (.pdb) at the Web server in the location registered in step 1.

    [!NOTE]
    If the business logic handler fails to build because the assembly is in use, type the command iisreset on the Web server at the command prompt to reset the Web server.

  5. Synchronize the subscription with Web synchronization enabled. During synchronization, the Web server loads the registered assembly.

  6. Using the Visual Studio .NET debugger, attach to the one of the following processes on the Web server:

    • w3wp.exe - Windows Server 2003.

    • inetinfo.exe - Windows 2000 and Windows XP.

  7. In the Output window, check the debug output to verify that the symbols for the registered assembly loaded properly. If the symbols were not loaded, ensure that the correct .pdb file was copied in step 4, and repeat step 5.

  8. Execute insert, update, or delete commands against the subscription or publication database. The command and execution location depends on the method being debugged.

  9. Using the Visual Studio debugger, attach to the w3wp.exe process.

  10. Synchronize the subscription again, using Web synchronization.

  11. Assuming that no other breakpoints are set and the proper commands are replicated, the execution stops when it reaches the breakpoint in the business logic handler.

Related content