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.