I had created three sql server instances in one development database server as in Option D7 diagram. My plan is to split the databases exactly as in diagram.
The instances are:
- SQLCONFIGDB - This instance will have ConfigDB STG, ConfigDB UAT, Metrics CacheDB databases.
- SQLIVANTISMSTG - this instance will have IvantiSM STG and ReportDB STG databases.
- SQLIVANTISMUAT - This instance will have IvantiSM UAT and ReportDB UAT databases.
When do Push in Ops Console from Production to Staging, there is no option to select the staging instance (SQLIVANTISMSTG). The target DB Server only list the configdb instance. When completed, The IvantiSM database had been created under SQLCONFIGDB instance instead in staging instance.
Do I miss some steps?