azzam223 Active Member Licensed User Longtime User Aug 31, 2017 #1 hello I need to Synchronize my remote database what is the best way to do that I want to sync database tables every time If I load all data in local database and then make some query to add and remove the data that changes is this best way to sync or there are best way
hello I need to Synchronize my remote database what is the best way to do that I want to sync database tables every time If I load all data in local database and then make some query to add and remove the data that changes is this best way to sync or there are best way
Erel B4X founder Staff member Licensed User Longtime User Aug 31, 2017 #2 There are all kinds of ways to synchronize databases. The exact details depend on the exact requirements. One possible and relatively complete solution is CloudKVS. Upvote 0
There are all kinds of ways to synchronize databases. The exact details depend on the exact requirements. One possible and relatively complete solution is CloudKVS.
azzam223 Active Member Licensed User Longtime User Aug 31, 2017 #3 is this is the best way if I have big databases Upvote 0
azzam223 Active Member Licensed User Longtime User Aug 31, 2017 #4 Erel How can I use CloudKVS with my database If all tables have changes Upvote 0
Erel B4X founder Staff member Licensed User Longtime User Aug 31, 2017 #5 You need to first learn how CloudKVS works. Upvote 0
azzam223 Active Member Licensed User Longtime User Aug 31, 2017 #6 I know that Erel But My question is How I can Add this feature To my data without Create New tables I need the make the changes To my tables not to another tables Upvote 0
I know that Erel But My question is How I can Add this feature To my data without Create New tables I need the make the changes To my tables not to another tables
Erel B4X founder Staff member Licensed User Longtime User Sep 2, 2017 #7 It is not possible. CloudKVS is a key value store. Upvote 0
azzam223 Active Member Licensed User Longtime User Sep 2, 2017 #8 Ok Is there Another way To Do that Upvote 0
Erel B4X founder Staff member Licensed User Longtime User Sep 3, 2017 #9 Yes. Send queries and request the new data (based on a date column) and upload the new local data. Upvote 0
KMatle Expert Licensed User Longtime User Sep 3, 2017 #10 azzam223 said: is this is the best way if I have big databases Click to expand... Whay do you need a full sync? You never synchronize a big database with a "small" device (except you need a backup at a 2nd db server). Just show the first 100 rows and retrieve the next if needed. Upvote 0
azzam223 said: is this is the best way if I have big databases Click to expand... Whay do you need a full sync? You never synchronize a big database with a "small" device (except you need a backup at a 2nd db server). Just show the first 100 rows and retrieve the next if needed.
