Information:

How to move the Equitrac database from a local SQL database to a remote SQL database server

This information is provided as a courtesy. Database maintenance is a customer responsibility. Kofax Support does not provide assistance or support for database version migrations.

Refer to any Microsoft documentation in regards to migrating a database from SQLExpress to MSSQL. 

Before moving a CAS database from local SQL Express to MS SQL Server you must ensure you have a FULL backup of the Equitrac database and the connection string properties for the new database.

- Stop the CAS service.

- Perform the migration from SQLExpress to MS SQL Server as per Microsoft documentation.  (Backup database on old server and restore database on new server)

- Equitrac service account must have access to the new database

For Equitrac Office / Equitrac Express 5.0 to 5.7

- Go to registry editor and browse to HKLM -> Software -> Equitrac -> CAS -> database

- Right mouse click on the database folder and select export.  Export the keys to a convenient location as a backup.

- Repeat these steps for the entries in HKLM -> Software -> Wow6432Node -> Equitrac -> CAS -> database

- Update the connection strings accordingly in both locations.

- Snapshot Isolation must be enabled on the EQCAS database by running the SQLServerOpt.sql script in the C:\Program Files\Equitrac\[Office or Express]\Database folder on the CAS server.  See details in                         

- Restart the CAS server after applying the changes.

For Equitrac Office / Equitrac Express 4.2.x 

- update the ODBC System DN settings with the new database.  

- Snapshot Isolation should then be enabled on the EQCAS database by running the EQCASSQLEXPR2005.sql script in the C:\Program Files\Equitrac\[Office or Express]\Database folder on the CAS server.   See details in .

- Restart the CAS service.