Single or Multiple DBs

One reader wrote in asking about single versus multiple databases for Commerce Server sites. From a security and deployment management perspective, having a separate database for each resource is the way to go. However, this is not the default of the PuP utility. So, when setting up a site, I would always recommend using a Custom UnPuP and putting each resource in its own database. If you have an existing site, the easiest way to get it from a single to multiple database is to PuP it and then UnPuP it again. This has to be done quite carefully – especially if you are using a non-standard schema for profiles or have made any alterations or extensions to other schemas without using the management tools provide by Commerce Server – as these would need to be handled manually after the UnPuP.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.