Click here to Skip to main content
15,887,821 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
how to data pass from online database to local database

What I have tried:

how to data pass from online database to local database
Posted
Updated 12-Feb-19 20:33pm
v2
Comments
Mohibur Rashid 13-Feb-19 1:56am    
Simplest algorithm is
Read From Online
Write to Local
I hope this works for you!

1 solution

This is not a simple subject - it gets to be extremely complicated, very, very quickly.

The problem is that getting info from a remote DB is easy - but databases aren't static things, they get updated. And the main reason for adding a local database is so that the local copy can be used "offline" - and what happens to data that is updated on the local DB? Should it be updated on the remote DB as well? And what if someone else also updated the same data - which one should "win"?

This is a problem called Database Replication and you need to think long and hard before you leap into it: your DB(s) must be designed very carefully and specific rules established before you even start trying to code.
Have a read here: Replication (computing) - Wikipedia[^] and then follow a few links:
Database Replication - Google Search[^]
database replication and reconciliation[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900