Sync External Database to Local Tables

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Sync External Database to Local Tables

Postby leadtael » Sat Apr 04, 2015 3:56 pm

I am currently using Base with an hsql local database file setup. I want to be able to sync the data from/to the local database files to an external mysql source. The reason for this is that I have need for the database to be local because it is used in locations that are remote and there is no network connectivity, but I'd like to have the ability to open it up and sync the database down, since there are multiple people who use this database. I essentially just want to cache the database for offline use.

Does anyone have any ideas on how I could accomplish this?

Thanks for any help!
OpenOffice 4.4.1.2 on Windows 8
leadtael
 
Posts: 1
Joined: Sat Apr 04, 2015 3:45 pm

Re: Sync External Database to Local Tables

Postby Villeroy » Sat Apr 04, 2015 10:58 pm

This might be possible running your own MySQL server on localhost. I think that OpenOffice can not contribute anything here.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24405
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Sync External Database to Local Tables

Postby DACM » Fri Apr 10, 2015 6:51 pm

leadtael wrote:I am currently using Base with an hsql local database file setup. I want to be able to sync the data from/to the local database files to an external mysql source.

I essentially just want to cache the database for offline use.

Offline data synchronization among multiple users is extremely complex, particularly if both online and offline users could potentially update the same data. Further migration of that data between two DBMS's (HSQL and MySQL) adds another layer of complexity to the solution.

But if you can live with non-concurrent, synchronous updates, using only one DBMS, then the solution becomes quite easy. For instance, you could move your HSQL database into a cloud folder (Dropbox, Google Drive, Spideroak, etc.) for both offline access and automatic synchronization when online. 'Synchronization' is actually file 'replacement' in this scenario, but older versions of the database are accessible. Users would have to agree not to 'update' the database simultaneously. This could be accomplished through a group message such as "Dan is updating the database. Please standby."

And note, you can run a 'split HSQl database' from a cloud folder on multiple computers when using a 'portable' solution.
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
User avatar
DACM
Volunteer
 
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 3 guests