Database overview
Databases required for this installation include databases specific to Touchstone/ Touchstone Re and to property exposure.
Important note on setting up multiple SQL servers
If you are working with multiple SQL servers make sure to set up AIRProject.dbo.tDataServer accordingly.
AIRProject.dbo.tDataServer has one entry in the master server with Master SQL Server Instance name as DataServerName and IsMaster = 0.
| DataServerName | IsMaster |
|---|---|
| MasterInstance-DB1\SQL2022 | 0 |
AIRProject.dbo.tDataServer has two entries in the child server with Child SQL Server Instance name as DataServerName and IsMaster=0, and Master SQL Server Instance name as DataServerName and IsMaster = 1.
| InstanceName | IsMaster |
|---|---|
| ChildInstance-DB1\SQL2017 | 0 |
| MasterInstance-DB1\SQL2022 | 1 |