Log files collect information about SQL Source Control while you use it. These files are useful if you're working with Redgate support to fix a problem.
By default, the log level of SQL Source Control is set to Warning (see the table below). This can produce large log files. If you're troubleshooting a specific problem, you may want to change the amount of logging.
Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.
Inside the <EngineOptions>
tags, add:
<LogLevel>your specified log level</LogLevel> |
You can specify:
Log level | Effect |
---|---|
None | Disables all logging. |
Debug | Logs additional debug information. |
Trace | Logs stack trace after an exception. |
Information | Logs information collected when getting changes in the Get latest tab. |
Warning | (Default) Logs information collected when minor errors occur. |
Error | Logs information collected when mid-level errors occur. |
Fatal | Logs information collected when fatal errors (ie crashes) occur. |
Serious | Combines the warning, error and fatal log levels (ie logs information from all error types). |
Default | Combines the debug, trace, information and serious log levels. |
All | Logs all messages. |
E.g.
<?xml version="1.0" encoding="utf-8" standalone="yes"?> <!----> <EngineOptions version="3" type="EngineOptions"> <LogLevel>All</LogLevel> </EngineOptions> |
The file is case sensitive. Don't change the capitalization of the text. |
SQL Source Control saves log files with the setting you specified.
By default, log files for all Redgate tools are located in: %LOCALAPPDATA%\Red Gate\Logs