Offline database update * Advice *
I need some advice.
I have 2 databases One on my Server (\\backoffice\HHD) and on on the PoS terminals.
When the back office changes anything how can i Make it so that the PoS terminals will update thier copy of the database?
Example if a price change is done on a product the PoS will use the new price becasue they are running from the network database BUT if they system goes offline they will divert to the local database.
My problem is HOW can I keep the local database uptodate when ever anything is changed on any of the databases on the back office?
I have the following databases to keep uptodate
> Cashiers PoS
> PoS Settings (recipit settings, card settings etc)
I Was thinking about deleting the databases and just copying them again BUT this will be two slow if I have 10-20 terminals downloading at the same time. also I just want to update the feilds that have been changed eg
PoSPrice = "0.56" change to "0.72" I just want it to update this NOT the whole recorld.
Any recommandation is most welcome
Thanks for the advice
What kind of database are you using? MS Access and SQL Server both support replication for just this scenario.
Please post questions to the forums, where others may benefit.
I do not offer free assistance by e-mail. Thank you!
I am using both.
my Main online system is powered by MS SQL Server 2000 and the local databases are MS Access 2000.
how do I use the replication then? I have not heard of it before?
By ryanlcs in forum VB Classic
Last Post: 06-13-2005, 12:42 PM
By MichaelChoi in forum ASP.NET
Last Post: 01-15-2003, 08:37 PM
By Austin in forum VB Classic
Last Post: 11-26-2001, 10:26 AM
By Jeff Pipes in forum VB Classic
Last Post: 11-13-2001, 05:08 PM
By S N in forum VB Classic
Last Post: 09-06-2001, 01:43 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL