HSQL2.5 and replication - just curious

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

HSQL2.5 and replication - just curious

Postby gkick » Tue Nov 05, 2019 5:31 am

Hi,

HSQL2.5 db Replication - just curious
As I remember from the previous decade replication involves a master db somewhere on a fileserver and some replicas on notebooks, the salesguys end of day procedure once back in the office hooks up to the server and synchronises with the master.
The HSQL manual talks about export/import PERFORM SCRIPTS but does not seem to have any detail ?
So I am just wondering if it would be possible to use the export and import Scripts for some automated backup restore.
Something along the line of run an export script(timestamped) then have a form with a filepicker to select the import script to restore whatever backup to the same db which originated the export?
Anyone using replication with HSQL?

Thks.
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 246
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: HSQL2.5 and replication - just curious

Postby UnklDonald418 » Tue Nov 05, 2019 6:19 pm

Have you looked at
https://sourceforge.net/p/hsqldb/discussion/
There are some threads on the subject in both the Open Discussion and Help forums
Search for replicate
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1321
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: HSQL2.5 and replication - just curious

Postby gkick » Wed Nov 06, 2019 5:59 am

@unclDonald418,

Thanks for the link, had a look at the site previously, however some of the posts are pretty dated going back to 2014 and earlier covering version 1.7

GK
Libre Office 6.2 on Windows 10 HSQL 2.5 backend
gkick
 
Posts: 246
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 2 guests