I figure this can be done? But I (google) can't seem to find any hints as to how this is done apart from changing the connection string to another existing database.
Is there any easy way to have uCommerce install itself in a separate database (maybe picking up the connection string from the web.config file, if the "uCommerce" one is already present) ?
Or is this the "hard way", installing uCommerce, and then moving the tables and content to another database "manually"?
Installation will always occur into the Umbraco database, so it's the hard way.
Alternatively you can roll out the database manually by running the uCommerce migrations against a clean database. The scripts are found in /umbraco/ucommerce/install. Just run them in order and make sure that you update the uCommerce_SystemVersion table with the highest migration number so uCommerce can migrate your database going forward.
Running uCommerce in a separate database
I figure this can be done? But I (google) can't seem to find any hints as to how this is done apart from changing the connection string to another existing database.
Is there any easy way to have uCommerce install itself in a separate database (maybe picking up the connection string from the web.config file, if the "uCommerce" one is already present) ?
Or is this the "hard way", installing uCommerce, and then moving the tables and content to another database "manually"?
thanks,
Steen
Installation will always occur into the Umbraco database, so it's the hard way.
Alternatively you can roll out the database manually by running the uCommerce migrations against a clean database. The scripts are found in /umbraco/ucommerce/install. Just run them in order and make sure that you update the uCommerce_SystemVersion table with the highest migration number so uCommerce can migrate your database going forward.
Got it sorted (the hard way), thanks.
thanks,
Steen
How do you specify the uCommerce-specific connection string?
<add name="UCommerce".... under connectionStrings section i web.config...
Should do the trick
is working on a reply...