db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brett Wooldridge <brett.wooldri...@gmail.com>
Subject Re: Opening/Converting a Derby Embedded DB with the Derby Network Server
Date Sun, 28 Mar 2010 23:39:38 GMT
SQuirreL is a tool with copy DB functionality.  I don't know if it
handles LOBs.  If it works, I would appreciate it if you post back here.

Brett

Sent from my iPhone

On Mar 29, 2010, at 7:32, "[SAS] Justin Swall"
<JSwall@swallservices.com> wrote:

> Unfortunately, the upgrade did not migrate the data from the HSQLDB to
> the new Derby DB.  I have posted on their forms for help.  Does anyone
> know if there is a utility available to migrate existing data from
> HSQL
> to Derby?
>
> Regards,
>
> Justin Swall
> Swall's Associated Services
>
>
> -----Original Message-----
> From: [SAS] Justin Swall [mailto:JSwall@swallservices.com]
> Sent: Sunday, March 28, 2010 2:50 PM
> To: Derby Discussion
> Subject: RE: Opening/Converting a Derby Embedded DB with the Derby
> Network Server
>
> I figured out my first problem.  The version of the LOB we are
> currently
> using is one subversion older than the new version I am doing my
> testing
> on.  The old version of the software used HSQL and the new version
> uses
> Derby so what I actually have is an old HSQL DB.  I'm going to install
> the old version on my test system, attach the HSQL DB, then do an
> in-place upgrade to the latest subversion as it should update the DB
> as
> part of the upgrade.  Hopefully once upgraded I'll be able to figure
> out
> how to attach it to the network server without incident.  I'll keep
> this
> thread updated as I know more.
>
> Justin Swall
> Swall's Associated Services
>
>
> -----Original Message-----
> From: [SAS] Justin Swall [mailto:JSwall@swallservices.com]
> Sent: Sunday, March 28, 2010 2:22 PM
> To: derby-user@db.apache.org
> Subject: Opening/Converting a Derby Embedded DB with the Derby Network
> Server
>
> I have an LOB application that uses a Derby Embedded DB (Openbravo
> POS @
> sourceforge.net).  Their application does support using the network
> server however so I spent some time over my weekend running some tests
> with a copy of the app, installing the JDK & Derby and seeing if I can
> get it talking to the network server instead of the embedded
> server.  So
> far so good, I was able to get it to connect to the network server and
> create a new DB and it is now successfully working off the new DB.
>
> My question is I currently have a copy of the embedded DB files (the
> .script and .properties files).  How can I get the data out of this
> embedded DB and over into a DB that can be mounted with the Network
> Server?  Is there some way to just directly mount this existing DB in
> the network server or does it need to be converted?
>
> I'm certain that this is a pretty basic question but I swear I've
> googled and searched the mailing list archives and so far can't figure
> out what to do so I'm looking to the experts for help.
>
> Thanks in advance.
>
> Justin Swall
> Swall's Associated Services

Mime
View raw message