Versions Compared

Version Old Version 11 New Version Current
Changes made by

David Malisch

David Malisch

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

This can only be completed after a successful install of the Fall 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.35

    • 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.

  1. Delete the files/folders in found in the following directory: C:\ProgramData\Tracs\TraCSClientUpdate\.

  2. Delete the DistributionLog.xml file found in the following directory: C:\ProgramData\Tracs\Settings\.

  3. 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.

...