Synchronising multiple databases

[Stealth549]

Hello, I am currently designing a management system for the company that I work for and I need help as to how I can design the database. The company will have multiple stores. The plan is to have a central database on the internet (mssql). The idea it to have a local database on site, so in the event of internet access not being available the system is unaffected. How would I go about having the database, local and remote update them self’s? The issue I could see is the primary keys being different on all the databases. Also how would you do it?

Thanks

 

[cjard]

Lookup "Data Replication"