You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Arun Kumar <ar...@gmail.com> on 2004/11/24 13:22:54 UTC
MySql datbase to Derby
Hi,
How i can shift MySql database (Eg: abc.sql) to Derby?
Arunkumar.H.G
Re: MySql datbase to Derby
Posted by Arun Kumar <ar...@gmail.com>.
Thanx buddy i got it!
On Mon, 29 Nov 2004 21:41:27 +0100, Alexander Schatten <al...@gmx.at> wrote:
> Arun Kumar wrote:
>
> >Hi,
> >Thnx, i will follow your instructions, can you intimate me from where
> >i can get "hsqldb".
> >
> >
>
> 5 seconds:
> Google:
> "hsqldb"
> first hit:
> http://hsqldb.sourceforge.net
>
> .... :-(
>
>
Re: MySql datbase to Derby
Posted by Alexander Schatten <al...@gmx.at>.
Arun Kumar wrote:
>Hi,
>Thnx, i will follow your instructions, can you intimate me from where
>i can get "hsqldb".
>
>
5 seconds:
Google:
"hsqldb"
first hit:
http://hsqldb.sourceforge.net
.... :-(
Re: MySql datbase to Derby
Posted by Arun Kumar <ar...@gmail.com>.
Hi,
Thnx, i will follow your instructions, can you intimate me from where
i can get "hsqldb".
Regards
Arunkumar.H.G
On Sun, 28 Nov 2004 18:49:29 +0100, Alexander Schatten <al...@gmx.at> wrote:
> Arun Kumar wrote:
>
> >Hi,
> >
> >How i can shift MySql database (Eg: abc.sql) to Derby?
> >
> >
> >
>
> I have not tried this specifically; but you could have a look at hsqldb:
>
> there is data-transfer tool included, that works with arbitrary JDBC
> sources; what is usually not working is, to transfer the database
> structure; particularly away or to mySQL.
>
> I would suggest to try the following:
>
> (1) Manually duplicate the database structure on Derby
>
> (2) Start the hsqldb transfer tool and transfer all data from mySQL to Derby
>
> good luck
>
> Alex
>
>
Re: MySql datbase to Derby
Posted by Alexander Schatten <al...@gmx.at>.
Arun Kumar wrote:
>Hi,
>
>How i can shift MySql database (Eg: abc.sql) to Derby?
>
>
>
I have not tried this specifically; but you could have a look at hsqldb:
there is data-transfer tool included, that works with arbitrary JDBC
sources; what is usually not working is, to transfer the database
structure; particularly away or to mySQL.
I would suggest to try the following:
(1) Manually duplicate the database structure on Derby
(2) Start the hsqldb transfer tool and transfer all data from mySQL to Derby
good luck
Alex