Moving database to new SQL instance

SQL database can be moved to new instance by following these general guidelines.

1. Stop all related (Centero Agent Gateway and management portal) web sites from IIS server. This will ensure that database data is not modified
2. Move or copy database to new SQL instance. You can use any supported method to move or copy SQL databases like backup/restore, detach/attach etc. Make sure that same login permissions are available on new instance. By default login permissions are required for the Active Directory computer object for the server where Carillon web sites are installed, but this can be also SQL login or some other Active Directory user account. You can find the current authentication method from the web.config files connection strings mentioned on step 3.
3. On IIS server modify ConnectionString setting in web.config files in Centero Agent Gateway and management portal web sites to have new SQL instance
4. On IIS server modify registry value SQL Connection in HKLM\SOFTWARE\Centero\Agent\Modules\Carillon to have new SQL instance
5. Start all web sites that were stopped on step 1