SQL Server Express edition
Can we use SQL Server Express edition to host the SmartConnect database?
I’m coming across a situation where we need to migrate a SmartConnect database from a hosted server to on-premise server, but we already have a SmartConnect database on the on-premise server. We are still using SC version 2015, so we cannot provide a name for the SC database.
I’m coming across a situation where we need to migrate a SmartConnect database from a hosted server to on-premise server, but we already have a SmartConnect database on the on-premise server. We are still using SC version 2015, so we cannot provide a name for the SC database.
Answers
We haven’t officially tested SQL Server Express with SmartConnect however I’ve answered this same question many other times with “it should work fine” and haven’t ever heard back differently.
OK. I guess we will just have to test it. Thanks, Patrick.
How much maximum space required for SmartConnect database on SQL server 2016.?