How can I move my EventSentry database to a different (newer) Microsoft SQL Server?

To move an existing MSSQL database to a different server, simply detach the database from the existing server, copy it to the new system and reattach it. After the DB is online, simply initialize the database again and update all connection strings:

1. Stop all EventSentry services. If you are not using the collector, then all remote agents should be stopped as well.
2. Using SQL Server Management Studio, detach the EventSentry database.
3. Copy the database file(s) to the new Microsoft SQL Server.
4. Using SQL Server Management Studio, attach the EventSentry database.
5. In the EventSentry Management Console, locate the respective database action and update the connection string to point to the new server. You can do this in the text field or by clicking the "Create" button.
6. Click the Initialize or Update Database button which create the "eventsentry_svc" and "eventsentry_web" user accounts.
7. Save & deploy the configuration.
8. In the Web Reports navigate to Settings -> Profile Editor and adjust the database connection to point to the new database
9. Restart all EventSentry services that were stopped in step 1.

Your new database is now ready to be used. If the you are not using the collector, or if the collector is not configured for configuration deployment then the configuration will need to be pushed to all remote hosts.