Building a new cart, looking for DB advice
Posted on 2009-05-08
I have a specialized shopping cart written in .ASP and running on top an access database. Its also compatible with SQL. I have numerous clients that use this cart and in each case it's configured to a separate database to store their individual inventories.
I am getting ready to re-write the entire thing in ASP.NET and was wondering what the community throught about having all inventories run on top of a single SQL database or should I stick to the issolated database structure either with a ton of simmilar SQL databases or access files? I've been thinking about pros and cons for these for a while and need to make a decision.