Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 91688 invoked from network); 28 Nov 2004 17:49:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 28 Nov 2004 17:49:37 -0000 Received: (qmail 72999 invoked by uid 500); 28 Nov 2004 17:49:37 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 72969 invoked by uid 500); 28 Nov 2004 17:49:36 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: list-post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 72952 invoked by uid 99); 28 Nov 2004 17:49:36 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FORGED_RCVD_HELO X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: 195.3.96.89 is neither permitted nor denied by domain of alasan@gmx.at) Received: from warsl404pip6.highway.telekom.at (HELO email09.aon.at) (195.3.96.89) by apache.org (qpsmtpd/0.28) with SMTP; Sun, 28 Nov 2004 09:49:34 -0800 Received: (qmail 389058 invoked from network); 28 Nov 2004 17:49:29 -0000 Received: from n890p026.dipool.highway.telekom.at (HELO gmx.at) ([212.183.121.58]) (envelope-sender ) by email09.aon.at (qmail-ldap-1.03) with SMTP for ; 28 Nov 2004 17:49:29 -0000 Message-ID: <41AA0FA9.70009@gmx.at> Date: Sun, 28 Nov 2004 18:49:29 +0100 From: Alexander Schatten User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: de-at, en-gb, en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: MySql datbase to Derby References: <208574340411240422241f3ba5@mail.gmail.com> In-Reply-To: <208574340411240422241f3ba5@mail.gmail.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N 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