Hybrid Installation (Sitecore in Azure IaaS and Database in Azure SQL)

Hi All,

I need to install Sitecore 9.3 / 9.2 in Azure Iaas and use database in Azure SQL (Hybrid Installation). Please suggest how to achieve using customized WDP packages ?

Please share your views about this Hybrid Installation. 

 

Thanks & Regards,

Ravi

  • I know this is an old topic, but in case anyone is looking for a similar answer, after speaking it through with Sitecore support, one possibility in achieving this would be to do to a standalone installation of Sitecore on a VM including the databases on a local SQL database server, and then migrate them to an Azure SQL instance, using the deploy functinoality in SSMS. Then, on your VMs, you can install the Sitecore roles and skip the database install operation (more info here: sitecore.stackexchange.com/.../how-do-skip-the-db-deploy-task-in-sitecore-install-framework). This should allow you to install your instances without having to deploy the databases, which were already migrated.

    You may need to tweak some of the SIF files. Fie example, in the "xp1collection.scwdp.zip" WDP package, there is a "Sitecore.Xdb.Collection.Database.Sql.dacpac" as well as a "Sitecore.Xdb.Collection.Database.Sql.Azure.dacpac". If installing to Azure, update the following:

    "Sharding.DacPac.Path": "[joinpath(variable('Sharding.Root.Path'), 'Sitecore.Xdb.Collection.Database.Sql.dacpac')]"

    and change it to:

    "Sharding.DacPac.Path": "[joinpath(variable('Sharding.Root.Path'), 'Sitecore.Xdb.Collection.Database.Sql.AZURE.dacpac')]",