Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of rmoazeni@gmail.com designates
 64.233.182.185 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=kTcYTDFpU78IMJCJjV8b5EkygG6YZSVgXXngF42RqmTx8na0F/Sm1e/JfmgDEIZp5KoGpN1i+/KysYEtn3qe2ff3HY0FdBRn9ZtG1+ypqHimuUSqqx1mlRdHSzpsvzeZvvBKeSsnWmYd8kcO5c7Gm7CHD47Vbj/aoycpQTcxKAg=
Message-ID: <926963240607121104tdf7d7b2scf3502cdafc58475@mail.gmail.com>
Date: Wed, 12 Jul 2006 11:04:36 -0700
From: "Ramin Moazeni" <rmoazeni@gmail.com>
To: derby-dev@db.apache.org
Subject: Re: Google SOC:MySQL to Derby Migration tool design question
In-Reply-To: <44B41588.6060806@sun.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <926963240607111046p8103d89u84fa785fe957d272@mail.gmail.com>
	 <44B41588.6060806@sun.com>

Hi David

I do not believe the split will be exposed to the normal user.
However, in case of an error, the user might have to follow two
different paths to fix the problem. For example, modifying xml files
for ddlutils component and modifying sql statements
for the DatabaseMetadata approach.

I hope I answered your question

Thanks,
Ramin

On 7/11/06, David Van Couvering <David.Vancouvering@sun.com> wrote:
> If this is the simplest approach in terms of design and code re-use it
> sounds good to me, *as long as* the user doesn't have this split exposed
> to him/her, and instead sees one seamless tool and user experience.
>
> In particular, if Things Go Wrong, what is the user flow/experience --
> how does the user back things out, figure out what went wrong, etc.
> Does this approach complicate error determination and recovery?
>
> Thanks,
>
> David
>
> Ramin Moazeni wrote:
> > Hello
> >
> > As per my earlier post regarding the design document for MySQL to
> > Derby Migration tool located at
> > http://wiki.apache.org/db-derby/MysqlDerbyMigration/DesignDocument, I
> > proposed two approches: 1) based on the use of DatabaseMetaData and 2)
> > using DdlUtils tool.
> >
> > The DdlUtils tool seems not be capable of migrating views, CHECK
> > constraints,  and stored procedures. I would like to know what do you
> > think if DdlUtils tool can be reused for migrating the tables and
> > Indexes, and use the DatabaseMetadata for migrating views and stored
> > procedures? .....
> >
> > Your comments are appreciated.....
> >
> > Thanks
> > Ramin Moazeni
>