1. Run ATS.CM4D.Conestoga.DbMigrator.exe.
2. When prompted, hit Y to continue.
3. Wait for the process to complete. When it is finished running, the Command Prompt will read ''Successful migration. Press any key to exit application".
Notice
If
you created the Results database object in SSMS before running the DbMigrator,
there are some settings that must be set manually in SQL server. Your
SQL Server may already use some of these settings by default, but you
should confirm these settings are correct or you may have issues with
the Results database.
4. After running the DbMigrator tool, open SQL Server to confirm that the database object was created with the correct properties.
a. Run SSMS.
b. Right-click on the Results database created by DbMigrator.
c. Modify the Properties.
d. Go to the Options page and check the following options are set:
i. Recovery Model - Simple
ii. Allow Snapshot Isolation - True
iii. Is Read Committed Snapshot On - True
e. Click OK.