Has anyone gone down the SQL route for Storefront Databases? I have a large deployment that is looking to upgrade Storefront to the next LTSR and considering switching to this over the ESENT DB. https://docs.citrix.com/en-us/storefront/2402-ltsr/configure-manage-stores/store-subscription-data-in-sql-server.html

I moved mine over to SQL a while back (2 years maybe?). Best thing I did for the Subscription store stability. I was having issues with the service crashing and the local DBs being out of sync and users upset because their favorites would change randomly or not save. This move also allowed for some easy queries of the store and simple reset of users favorites when needed. I have a document with some queries that I will try to get posted and share, but I'm not sure they are much different from the ones in the documents.

Dennis, no problems with upgrades afterwards?

No issues at all with upgrades afterwards, so far.

Sounds almost to go to be true! Well, I'll migrate every Storefront DB from now on 🙂

I'm super happy with it myself for sure. It wasn't a terribly difficult migration either as I recall. There were a few users that had to have the favorites rebuilt due to what appeared to be corruption issues in the ESENT DB where there were just invalid data entries, but having the ability to just nuke the entire user out with a command it wasn't terrible. I am sure I migrated well over 10,000 user subscription sets and had to fix less that 10 user complaints and I haven't had the service issues since the migration.

We have been using SQL DB for 5 years. No issues