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