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 SQL Complete

      Logging is a standard mechanism used in many software tools to capture detailed information about application behavior, errors, and performance issues. It is particularly useful when diagnosing problems that are difficult to reproduce or analyze in ...

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

      Logging is essential for diagnosing complex issues and capturing technical details that may not be immediately visible through the user interface. When troubleshooting failures or unexpected behavior in SSMS add-ins that do not provide built-in ...

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

    • Error When Creating a Linked Server with ODBC Driver: "Data source name not found"

      The error "Data source name not found" typically indicates that Microsoft SQL Server is unable to locate or access the specified ODBC data source. To resolve this issue, make sure that: The ODBC driver is correctly installed on the same machine where ...