I have umbraco running on mysql. I also have sql server express on the same machine, and I would like to run ucommerce on that. Is there any way for me to install uCommerce to the SQL server instance?
The simplest way is probably to get a clean Umbraco install up and running on SQL Server, install uCommerce on that, and move configs to your existing install manually (UrlRewrites.config, ui.xml, web.config, language files). uCommerce has a separate connection string so you can point that guy to the SQL Server and leave the Umbraco connection string pointing to the MySQL.
Upgrading to newer version of uCommerce will be a continual hassle though as uCommerce picks on the Umbraco connection string on each install and uses that to update its database.
I'll look into updating the code base to support your scenario better as it's not a scenario we've seen before.
Install to a different DB
Hi,
I have umbraco running on mysql. I also have sql server express on the same machine, and I would like to run ucommerce on that. Is there any way for me to install uCommerce to the SQL server instance?
Thank you!
The simplest way is probably to get a clean Umbraco install up and running on SQL Server, install uCommerce on that, and move configs to your existing install manually (UrlRewrites.config, ui.xml, web.config, language files). uCommerce has a separate connection string so you can point that guy to the SQL Server and leave the Umbraco connection string pointing to the MySQL.
Upgrading to newer version of uCommerce will be a continual hassle though as uCommerce picks on the Umbraco connection string on each install and uses that to update its database.
I'll look into updating the code base to support your scenario better as it's not a scenario we've seen before.
Well I ended up doing something similar.
I installed a clean Umbraco on SQL Server and copied the data from the old install to the new one.
The process, a side from not being a lot of fun in general, also requires defering constraints.
Took me some time to wrap my head around that.
Once I had an SQL server mirror of my MySQL, I just pointed the old Umbraco to the new SQL server DB,
and it didn't even skip a beat. From there uCommerce was easy to get running.
Thank you!
Thanks for being awesome and posting the follow-up in the forum. #h5yr!
is working on a reply...