Install Ucommerce in separate database

Ucommerce by default is installed in the same database as your CMS.

All tables are prefixed with "uCommerce_", so they do not interfere with CMS or custom tables.

In order to install Ucommerce in its own database, a named connection string must be added prior to the Ucommerce installation. After the CMS has been installed and before Ucommerce is installed, add a connection string named "ucommerce" to the relevant configuration file.

    
    <!--Umbraco: /web.config-->
    <!--Sitecore: /App_Config/ConnectionStrings.config-->
    <!--Sitefinity: /App_Data/SitefinityConfiguration/DataConfig.config-->
    <add name="ucommerce" connectionString="user id=?;password=?;Data Source=.;Database=Ucommerce" />
    

After the connection string has been added, run the Ucommerce installation and it will automatically pick up the connection string.

Upgrading

When upgrading, Ucommerce will automatically use the named connection string if it exists.