| title | Global Settings (Logging) (AccessToSQL) | |
|---|---|---|
| description | Global Settings (Logging) (AccessToSQL) | |
| author | nilabjaball | |
| ms.author | niball | |
| ms.reviewer | randolphwest | |
| ms.date | 12/30/2025 | |
| ms.service | sql | |
| ms.subservice | ssma | |
| ms.topic | concept-article | |
| ms.collection |
|
|
| f1_keywords |
|
Use the Global Settings dialog box to specify the logging settings for SSMA. Typically, you would change these settings only when working with product support.
To access this dialog box, on the Tools menu, select Global Settings and then select the Logging button at the bottom of the left pane.
The following options are available under Messages Level:
| Option | Description |
|---|---|
| [all categories] | Used to set the logging level for all of the following options. |
| Collector | Collects metadata about the source schema and saves it to the project. |
| Converter | Converts structures of source database objects, such as tables and stored procedures, into corresponding [!INCLUDE ssNoVersion] structures. |
| Data migrator | Migrates data from the source database into [!INCLUDE ssNoVersion]. |
| Formatter | Sub-component of the Converter that generates scripts for the [!INCLUDE ssNoVersion] schema. |
| Graphical user interface | Messages that appear when you use the SSMA tool. |
| Linker | Resolves SQL identifiers and provides information to other components. |
| Other | All messages that aren't in any other category. |
| Parser | Parses the source schema. |
| Synchronizer | Loads source database objects into [!INCLUDE ssNoVersion]. |
| TreeConverter | Converts objects in the source metadata into [!INCLUDE ssNoVersion] metadata. |
For each option under Messages Level, configure one of the following logging levels for SSMA:
| Level | Description |
|---|---|
| Fatal Error | Write only fatal error messages to the log. |
| Error | Write error and fatal error messages to the log. |
| Warning | Write warning, error, and fatal error messages to the log. |
| Info | Write informational, warning, error, and fatal error messages to the log. |
| Debug | Write all messages, including debugging messages, to the log. |
The file path and name of the SSMA log files. To specify a different name, select the current path, and then select the Browse (...) button.
The maximum size of the log file in KB. The minimum size is 10 KB. The default size is 10240 KB.
When one log fills, SSMA renames the log file and starts a new one. By using this setting, specify the maximum number of log files to keep. The minimum is 2.