If you want to move your AgendaX database to a new SQL server, please proceed as follows:
- Stop the AgendaX Update Service
- Transfer the database to the new database server either by Backup / Restore or with the Import / Export Wizard in SQL Management Studio
- On the new database, check under Options that the ‘Simple Recovery Model’ is selected
- Create and authorize the SQL user used for AgendaX (AgendaXCfg.exe / DB User) on the new database (db_owner rights on the new database)
- In AgendaXCfg.exe, under Config / Edit, adjust the SQL data source to the new database
- Possibly adjust under AgendaXCfg.exe / DB user if the database user on the new database has a different name
- In AgendaXCfg.exe under Servers, select the first entry under ‘Available Servers’, click on ‘…’ under Datasource, then Edit and go through the SQL data source wizard again until the end. Adjust DB Username and DB Password here if necessary, then click ‘modify’ and OK, click Update and ‘No’ when asked to restart the service
- Check AgentX.ini and AgendaX.inc to see if there are no more references to the old database server (just to be on the safe side)
- Restart the AgendaX Update Service
After starting the service, please check the Windows Application Eventlog for any errors / warnings.
