We are in process of setting up the Sitecore 9.0.2 scaled environment for our upgrade from 7.2. On current production setup on 7.2 we have Analytics DB on a separate SQL Server than Core, Master, Web etc databases. Hence we want the same on Sitecore 9 as well. We will be having 1 CM, 1 Processing and 2 CD servers for the topology.
To achieve this Should I:
- While installing vanilla 9.0.2, add a parameter in installation script to provide dedicated SQL server details for Analytics Dbs? If yes how to define these additional parameters and which all DBs of SC9 platform should be moved to that SQL server?
- Or I just install the vanilla 9.0.2 in OOTB way, restore the analytics databases on a separate SQL server and update the connectionstring.config accordingly? If yes, just updating the connectionstring.config will suffice or I need to make additional tweaks as well?
Any help is much appreciated.