HSQL2.5 and replication - just curious

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

HSQL2.5 and replication - just curious

Post by gkick »

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.4.6 on Windows 10 HSQL 2.51 backend
UnklDonald418
Volunteer
Posts: 1540
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: HSQL2.5 and replication - just curious

Post by UnklDonald418 »

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.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
gkick
Posts: 324
Joined: Wed Aug 07, 2019 5:24 pm
Location: Chile

Re: HSQL2.5 and replication - just curious

Post by gkick »

@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.4.6 on Windows 10 HSQL 2.51 backend
Post Reply