Content Comparison

...

1. In SQL Server Management Studio (SSMS)

   1. Paste the query below to create the tracs_custom database. You should use the copy button in the code snippet below.

USE master
GO
CREATE DATABASE tracs_custom
GO
use tracs_custom
GO
DECLARE @sql1 VARCHAR(1000)
SELECT @sql1='ALTER DATABASE '+quotename(db_name())+' SET ALLOW_SNAPSHOT_ISOLATION ON
			 ALTER DATABASE '+quotename(db_name())+' SET SINGLE_USER WITH ROLLBACK IMMEDIATE
			 ALTER DATABASE '+quotename(db_name())+' SET read_committed_snapshot ON
			 ALTER DATABASE '+quotename(db_name())+' SET MULTI_USER'
exec(@sql1) 

...

Make sure to give your agencies TraCS SQL user owner rights to the database.

...

Run the Custom distribution file. (This adds state access levels.)

1. If you set up Task 6.1: Download Tables Upon Login

2. On your server you should be able to located the distribution and run it C:\ProgramData\TraCS\Download\Tables\*LocationID*\AgencySupportTable.dist.exml

3. Remove the Distribution Log. xml file

   1. Navigate to C:\ProgramData\TraCS\Settings

   2. Delete DistributionLog.xml

4. In the configuration manager, select the update tab.

   1. Click the run distribution button.

   2. Navigate to the C:\ProgramData\TraCS\Download\Tables\*LocationID*\ folder

   3. Select AgencySupportTable.dist.exml

...

Run the Distribution file found in your mobile distribution.

1. Remove the Distribution Log. xml file

   1. Navigate to C:\ProgramData\TraCS\Settings

   2. Delete DistributionLog.xml

2. In the configuration manager, select the update tab.

   1. Place the distribution file onto C:\ProgramData\TraCS\Distribution

   2. Edit the Distribution Deleting all except the following.

      Image Removed

3. Save

4. Click the run distribution button.

...

...

We need to run the WIPack now to fully configure all databases and run a DBSync too.

...