Re: Duplicate HSQLDB - Export/Import from one instance to a new instance.

--===============6676639091722864081==
Content-Type: multipart/alternative; boundary="0000000000001a26fe061c971b54"

--0000000000001a26fe061c971b54
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hello Ken
Not sure if this will cover all your requirements, but have a look at the
"Transfer Tool" utility.  Might be a place to start.
https://hsqldb.org/doc/2.0/util-guide/transfer-tool-chapt.html

Cheers,
Andrew Richardson

On Fri, Jul 5, 2024 at 4:18=E2=80=AFPM Ken Lemoine <[email protected]=
m> wrote:

> Hello,
>
> Apologies in advance if this has been asked before, I'm just not finding
> much information in the archives.
>
> We have a hsqldb instance that needs to be replicated to a secondary.
> I've tried and failed 3 different methods, mostly using the sqltool.jar a=
nd
> once by simply copying over the hsql.script file and crossing my fingers.
> The final attempt I just completed does seemingly create a valid
> 'exporteddata.sql' file, I can see it in there.  Then when I import it on
> the second machine, it also seemingly imports it - it outputs to stdout s=
o
> I know it did SOMEthing.  But, the data is not showing up in the
> application.
>
> This is the latest hsqldb, running on latest FreeBSD 14.
>
> I'll also be needing a way of fully automating this, to keep a second
> machine up to date, and have struggled also getting a script to do this,
> but at this point, I really just want to see if I can get this working
> manually.
>
> Any tips or hints, or a point in the right direction would
> be appreciated.
>
> Thanks!
>
> Ken
>
> *Ken Lemoine* | Deployment Manager
>
> (614) 344-6500
>
> www.cyberzek.com
> _______________________________________________
> Hsqldb-user mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hsqldb-user
>

--0000000000001a26fe061c971b54
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hello Ken<br></div><div>Not sure if this will cover a=
ll your requirements, but have a look at the &quot;Transfer Tool&quot; util=
ity.=C2=A0 Might be a place to start.<br></div><div><a href=3D"https://hsql=
db.org/doc/2.0/util-guide/transfer-tool-chapt.html">https://hsqldb.org/doc/=
2.0/util-guide/transfer-tool-chapt.html</a></div><div><br></div><div>Cheers=
,</div><div>Andrew Richardson<br></div></div><br><div class=3D"gmail_quote"=
><div dir=3D"ltr" class=3D"gmail_attr">On Fri, Jul 5, 2024 at 4:18=E2=80=AF=
PM Ken Lemoine &lt;<a href=3D"mailto:[email protected]">ken.lemoine@=
cyberzek.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" styl=
e=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);paddin=
g-left:1ex"><div class=3D"msg-919035450287370171">




<div dir=3D"ltr">
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Hello,</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Apologies in advance=C2=A0if this has been asked before, I&#39;m just not f=
inding much information in the archives.=C2=A0</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
We have a hsqldb instance that needs=C2=A0to be replicated to a secondary.=
=C2=A0 I&#39;ve tried and failed 3 different methods, mostly using the sqlt=
ool.jar and once by simply copying over the hsql.script file and crossing m=
y fingers.=C2=A0 The final attempt I just completed
 does seemingly create a valid &#39;exporteddata.sql&#39; file, I can see i=
t in there.=C2=A0 Then when I import it on the second machine, it also seem=
ingly imports it - it outputs to stdout so I know it did SOMEthing.=C2=A0 B=
ut, the data is not showing up in the application.</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
This is the latest hsqldb, running on latest FreeBSD 14.=C2=A0=C2=A0</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
I&#39;ll also be needing a way of fully automating this, to keep a second m=
achine up to date, and have struggled also getting a script to do this, but=
 at this point, I really just want to see if I can get this working manuall=
y.</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Any tips or hints, or a point in the right direction would be=C2=A0apprecia=
ted.=C2=A0=C2=A0</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Thanks!</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
<br>
</div>
<div style=3D"font-family:Aptos,Aptos_EmbeddedFont,Aptos_MSFontService,Cali=
bri,Helvetica,sans-serif;font-size:12pt;color:rgb(0,0,0)">
Ken</div>
<p><strong>Ken Lemoine</strong> | Deployment Manager</p>
<p>(614) 344-6500</p>
<p><a href=3D"http://www.cyberzek.com" target=3D"_blank">www.cyberzek.com</=
a></p>
<img src=3D"https://static.wixstatic.com/media/7044be_7929e43cb3664f7f87bd4=
b5d091e73f5~mv2.png/v1/fill/w_282,h_68,al_c,q_85,usm_0.66_1.00_0.01,enc_aut=
o/CYBERZEK%20Logo%20-%20Color%20-%20Horizontal.png" width=3D"222" height=3D=
"50">
</div>

_______________________________________________<br>
Hsqldb-user mailing list<br>
<a href=3D"mailto:[email protected]" target=3D"_blank">Hsql=
[email protected]</a><br>
<a href=3D"https://lists.sourceforge.net/lists/listinfo/hsqldb-user" rel=3D=
"noreferrer" target=3D"_blank">https://lists.sourceforge.net/lists/listinfo=
/hsqldb-user</a><br>
</div></blockquote></div>

--0000000000001a26fe061c971b54--


--===============6676639091722864081==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline


--===============6676639091722864081==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

--===============6676639091722864081==--