Task 1.6.1: Migrate from MS-Access to SQL Server Draft

...

This can only be completed after a successful install of the Fall 2020 Baseline and WIPack:2021 WIPack.

Info
Updating agency to latest WIPack version could be beneficial and needed if any issues come up trying this from minimum version levels mentioned.

Master Computer Baseline minimum version: 19.02.2735
- Only Update Baseline on the Master Computer
- Once agency is successfully migrated to SQL databases.
  - Run the 19.02.20 Baseline on the Master to put it back on same level as the rest of the computers.
WIPack minimum version: WIPack220207

...

Reset Pack Level on Master: If the agencies Access environment is running the latest pack, you can skip to Step #10, Log into TraCS and Export Support. Then continue through the migration steps.

Delete the files/folders in found in the following directory: C:\ProgramData\Tracs\TraCSClientUpdate\.
Delete the DistributionLog.xml file found in the following directory: C:\ProgramData\Tracs\Settings\.
Delete the whole TraCSPack line in the RegistryKeyName.ini file:
1. C:\Program Files\TraCS\RegistryKeyName.ini OR
2. C:\Program Files (X86)\TraCS\RegistryKeyName.ini
3. Example: TraCS Pack=WIPack130226b
4. Should look like below: Do not change the TraCS= line in your file.

...

Start Auto-Update on Master Computer - Task 1.5

Info
This step is only needed if you are making a new Master Computer.

Note

Skip Step #1 where is says to close Configuration Manager.

Stay logged into the configuration manager for now.

...