Architecture Question - Databases.

[NewsBot]

Hello all.

 

Having been down the road before where I have designed a system, told about it, and then realised the architecture was wrong from the off, I have decided this time to gather opinions on the best way to do this before starting anything.

 

Basically, as many of you will already know, my primary application is epos.

 

Each epos terminal holds a local SQLExpress database, containing all of its products etc.

All tables in the database have a Int primary key.

 

I have been asked to develop a web-based product management facility, so that users can log onto our web site, make product / price changes, and then send the changes down to their epos terminals.

 

I plan to have the epos terminals check for updates online every hour or so, and download and implement changes as necessary.

 

My main difficulty is figuring out how to store the data on my central SQL database.

 

I want to be able to store all of the product data etc from many customers in one database, but as I have said before, the product data tables have Int Indexes.*

 

Should I change indexes to a different type? If so, which?

 

Alternatively, should I look at a different way of storing each individual database seperately? Unfortunately I cannot use SQL express, as my web host (DiscountASP) do not support this.

 

I realise that I probably have missed a lot of important information, so please ask away ....

 

More...

 

View All Our Microsoft Related Feeds