How to Enable Logging for Source Control and Data Pump for SQL Server

How to Enable Logging for Source Control and Data Pump for SQL Server

Logging is essential for capturing detailed information about failures and issues in the program. If reproducing or diagnosing a problem is difficult, logging helps in providing a deeper investigation.

This guide applies to the following products:

  • dbForge Source Control for SQL Server
  • dbForge Data Pump for SQL Server

Steps to Enable Logging:

  1. Start Tracing:

    • Right-click on the database in SQL Server Management Studio (SSMS).
    • Select Source Control (for Source Control issues) or Data Pump (for Data Pump issues).
    • Navigate to Trace > Start Tracing.
  2. Reproduce the Problem:

    • Perform the actions that result in the issue to capture the problem in the trace logs.
  3. Stop Tracing:

    • Right-click on the database again.
    • Select the relevant product (Source Control or Data Pump) from the menu.
    • Navigate to Trace > Stop Tracing.
  4. Send the Trace Log to Devart:

    • Right-click on the database once more.
    • Select Source Control or Data Pump > Trace > Send Trace Log to Devart.
  5. Submit Your Information:

    • Enter your name, email address, and the ticket number provided in your support ticket (e.g., #12345).