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

--===============0277336863412106852==
Content-Type: multipart/alternative; boundary="0000000000004005e2061c97e901"

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

Hello again <sorry for the spam>
Out of curiosity, I looked into how to generate the Transfer Tool.  Here is
what worked for me on Windows.

cd hsqldb-2.7.3\hsqldb\build
gradlew hsqldbutil
java -cp ..\lib\hsqldbutil.jar org.hsqldb.util.Transfer --dump

Maybe this saves you a little time.
Cheers!

On Sat, Jul 6, 2024 at 12:59=E2=80=AFPM Andrew Richardson <[email protected]=
> wrote:

> 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 <ken.lemoine@cyberzek.=
com>
> 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 =
and
>> 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 o=
n
>> the second machine, it also seemingly imports it - it outputs to stdout =
so
>> 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
>>
>

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

<div dir=3D"ltr"><div>Hello again &lt;sorry for the spam&gt;</div><div>Out =
of curiosity, I looked into how to generate the Transfer Tool.=C2=A0 Here i=
s what worked for me on Windows.</div><div style=3D"margin-left:40px"><br><=
/div><div style=3D"margin-left:40px">cd hsqldb-2.7.3\hsqldb\build<br>gradle=
w hsqldbutil<br>java -cp ..\lib\hsqldbutil.jar org.hsqldb.util.Transfer --d=
ump</div><div><br></div><div>Maybe this saves you a little time.</div><div>=
Cheers!<br></div><div><br></div><div class=3D"gmail_quote"><div dir=3D"ltr"=
 class=3D"gmail_attr">On Sat, Jul 6, 2024 at 12:59=E2=80=AFPM Andrew Richar=
dson &lt;<a href=3D"mailto:[email protected]">[email protected]</a>&gt; wrote=
:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.=
8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"lt=
r"><div>Hello Ken<br></div><div>Not sure if this will cover all your requir=
ements, but have a look at the &quot;Transfer Tool&quot; utility.=C2=A0 Mig=
ht be a place to start.<br></div><div><a href=3D"https://hsqldb.org/doc/2.0=
/util-guide/transfer-tool-chapt.html" target=3D"_blank">https://hsqldb.org/=
doc/2.0/util-guide/transfer-tool-chapt.html</a></div><div><br></div><div>Ch=
eers,</div><div>Andrew Richardson<br></div></div><br><div class=3D"gmail_qu=
ote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, Jul 5, 2024 at 4:18=E2=
=80=AFPM Ken Lemoine &lt;<a href=3D"mailto:[email protected]" target=
=3D"_blank">[email protected]</a>&gt; wrote:<br></div><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex"><div>




<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><b>Ken Lemoine</b> | 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>
</blockquote></div></div>

--0000000000004005e2061c97e901--


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


--===============0277336863412106852==
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

--===============0277336863412106852==--