Hi ,
I have a situation where we have 200 locations ,each location is having a separate database.At each day end we update the transaction from all the database to a centralised database.Now the client wants to web enable the application.
Which approach will be suitable in this case 1.Distributed Database
2.Centralised Database.
What are the pros and cons of both.
Please give some suggestions.
Thanks
Amit