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.

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.

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.
Print Friendly, PDF & Email