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

    • Related Articles

    • How to Enable Logging for SSMS Add-ins Without Built-in Logging

      Logging is necessary to capture detailed information about failures and issues in the program. When it's difficult to identify, reproduce, or diagnose a problem, logging helps in performing a deeper investigation. This guide applies to the following ...

    • How to Enable Logging for Studios, Standalone Tools, and MiniTools

      Logging is essential for capturing detailed information about failures and issues within the software. If reproducing or diagnosing a problem is difficult, or if deeper investigation is needed, logging can help gather more information for ...

    • How to Connect to MySQL Server

      In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...

    • How to Enable Logging for SQL Complete

      Logging is required to capture detailed information about failures and issues in the program. If reproducing or diagnosing a problem is difficult, logging helps in performing a deeper investigation. This guide applies to the following product: ...

    • How to generate log file in Source Control for SQL Server

      1. Right-click on the database > Source Control > Trace > Start Tracing 2. Reproduce the problem 3. Right-click on the database > Source Control > Trace > Stop Tracing 4. Right-click on the database > Source Control > Trace > Send Trace Log to Devart ...