This article describes how to move the EVnearSync database to a different SQL server or a new version of MS SQL Server.

Step 1 – Determine location of databases

This is performed on the EVnearSync core server.
Taking note of the Enterprise Vault Directory and EVnearSync Directory databases.

• Using a text editor open \Program Files\QUADROtech\EVnearSync\CoreService.exe.config
• Locate around line 99
• Take note of the main and EV SQL Server listed in the “Data Source” field.
• Stop the EVnearSync Core Service.

This is performed on all the EVnearSync agent servers.

• Stop all the EVnearSync Agent Services.

Step 2 – Backup and copy the databases

This step is performed on the old SQL Server that hosts the EVnearSync database.

• Backup the EVnearSync database. (It tends to be easiest to use the built-in backup feature of SQL Management Studio).
• Copy the backup files to the new SQL server.

Note: Dedicated backup solutions with redirected restore will also work fine but are beyond the scope of this guide. Consult the backup software’s documentation for help with restoring database backups to a new host.

Step 3 – Restore the databases

This step is performed on the new SQL Server.

• Restore the databases using the copied backup files.

Step 4 – Update the locations of the databases

This should be preformed on the core server:

• Using a text editor open \Program Files\QUADROtech\EVnearSync\CoreService.exe.config
• Update the “main” “Data Source” with the new SQL server (around line 99)

• Using a text editor open \Program Files\QUADROtech\EVnearSync\WebUI\Web.config
• Update the “main” “Data Source” with the new SQL server (around line 10)

This should be preformed all agent servers:

• Using a text editor open \Program Files\QUADROtech\EVnearSync\AgentService.exe
• Update the “main” “Data Source” with the new SQL server (around line 36)

Step 5 – Resume operations using the new SQL Server

This should be preformed on the core server:

• Start the EVnearSync Core Service
• Restart IIS
• Check the Event Viewer for errors connecting to databases.

This should be preformed all agent servers:

• Start the EVnearSync Agent Service.
• Check the Event Viewer for errors connecting to databases.