SQL Change Automation 3

Logging and log files

Log files collect information about SQL Change Automation while you use it. These files are useful if you're working with Redgate support to fix a problem.

Changing the log level

  1. Close Visual Studio.
  2. Find the logging.config in SQL Change Automation extension folder (search Visual Studio folder to find it). There may be two such files - the one to edit is under the Extensions folder.
  3. Open logging.config in a text editor.

  4. Inside the <root> tag, edit:

    1. <level value="DEBUG" />

    You can specify:

    Log levelEffect
    NoneDisables all logging.
    DebugLogs additional debug information
    InfoLogs information collected when getting changes in the Get latest tab.
    WarnLogs information collected when minor errors occur.
    ErrorLogs information collected when mid-level errors occur.

Locating the log files

By default, log files for all Red Gate tools are located in %LOCALAPPDATA%\Red Gate\Logs.

Log files for the Visual Studio extension of SQL Change Automation are in %LOCALAPPDATA%\Red Gate\Logs\SQL Change Automation\VS.

Didn't find what you were looking for?