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" <[email protected]> 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:[email protected]] > 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:[email protected]] > Sent: Sunday, March 28, 2010 2:22 PM > To: [email protected] > 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
