This article provides guidance on migrating the data agent application SQLite database from one machine to another with minimal downtime and configuration. Follow the steps listed below or reach out to [email protected] if you’d like to schedule a meeting with a tech services team member for assistance.
Prerequisites:
Ensure both, new and old, data agent machines are up and reachable.
New machine needs proper network routing in place to reach various connector hosts/directories
Steps on Old Data Agent Machine
On the old data agent machine, navigate to the data agent installation path.
Typically located at C:\Program Files\GovWorxDataAgent\Service
Copy the database.db file in this folder to the desktop or somewhere accessible by the new machine
Steps on New Data Agent Machine
Download and install the data agent application on the new machine
Open services.msc
Stop GovWorx Data Agent Windows service
If previously using a domain account for SQL access, enter the Logon As account details in the service properties
While GovWorx Data Agent Windows service is stopped, copy the database.db file from old machine to the Data Agent installation directory on the new machine and overwrite existing file
We are replacing the SQLite database file on the new machine with that of the old machine
This SQLite database file contains all of the connector configuration and token
Start GovWorx Data Agent Windows service
Navigate to localhost:5000 and verify that the connector configuration is successfully migrated and that the connectors are running
Check Logs on the left toolbar and verify that there are no connection errors
On old machine, stop GovWorx Data Agent Windows service
(Optional) Reach out to [email protected] and advise that you’ve migrated the data agent and ask the tech services team to review logs and data flow
Once data flow is verified the GovWorx Data Agent application can be uninstalled on the old machine. Uninstall can be accomplished in Programs and Features.
Run Command: Press Windows + R, type appwiz.cpl, and press Enter.
Locate and select GovWorx Data Agent then select Uninstall