There are three to four different ways to access your 'Maintain Schemas' setting in Datamaker, depending on what release version you have. From this Maintain Schemas/Connections setting, you will be able to perform repository maintenance. This document will cover why repository maintenance is necessary, each way to access the Maintain Schemas setting, and the types of errors that can be resolved from performing repository maintenance.
After upgrading your instance of Test Data Manager (TDM), you will need to upgrade the repository tables. Your repository is where TDM, Datamaker, stores the metadata. From inside the 'Maintain Connections' setting window, you will need to 'Check Repository Tables' and 'Update Repository Transact-SQL'. Doing this will perform an analysis of the database tables in your repository and provide a report on these database tables relaying whether or not the repository tables need to be updated. In most cases, no updates will be needed, but if you do not run these tests and maintenance was needed, you can experience unexpected errors while using Datamaker. If updates are required, you will be given a script within the settings window and executing that script will perform the updates.
If you are encountering any database, repository, or license related errors, a good first troubleshooting step you can take is to perform repository maintenance.
This includes errors such as:
Listed below are the four ways to access this 'Maintain Connections' setting window, when to use the option, and what is involved when using it.
Option 1. Ctrl + Alt + M
Option 2. Help -> About -> Toolbox icon (Enabling maintenance mode)
Option 3. Add an environment variable called SCHEMASVISIBLE
Option 4. Settings -> Maintain Schemas
Note: All option instructions include how to access the Maintain Schemas/Connections Setting window, as well as how to complete your repository maintenance.
Option 1. Using the Ctrl + Alt + M keyboard shortcut
Option 2. Help -> About -> Toolbox icon (Enabling maintenance mode)
Option 3: Add an environment variable called SCHEMASVISIBLE
Option 4. Settings -> Maintain Schemas