Mike and Øyvind,
Thanks you for charing your experience, I will take this in
consideration as my project move on.
Regards
/Andreas
----- Original Message -----
From: Øyvind Harboe
[mailto:oyvind.harbo..ylin.com]
To: cayenne-use..ncubator.apache.org
Sent:
Wed, 15 Nov 2006 21:44:01 +0100
Subject: Re: DataPort
> On 11/15/06, Mike Kienenberger <mkienen..mail.com> wrote:
> > Yes, for straight-foward things, I've been able to use DataPort to
> > convert from Oracle to hsqldb. For other tables, I've used dbunit
> > export and import to xml.
>
> Manipulating databases in this fashion is not a job that Cayenne
> should take on, IMHO. I made a feeble naive attempt at adding
> downloadable backup/restore support using DataPort in my
> application(converting from any database to Derby), but quickly ran
> into rather hairy issues that showed that DataPort is not the way to
> go for that sort of thing.
>
> Some sort of interface between Cayenne and some other
> framework(DBunit? Others?) that could handle this type of database
> manipulation might be interesting.
>
> I'll certainly take DBuint for a spin eventually. Some of the problems
> that I don't see DataPort handling:
>
> - import/export w/foreign circular foreign keys, generated primary keys,
> etc.
> - add/remove fields from tables
> - creating a snapshot(backup & restore built into the application
> without using database specific functionality).
> - fixing corrupted database(e.g. duplicate primary keys)
>
> --
> Øyvind Harboe
> http://www.zylin.com
>
>
This archive was generated by hypermail 2.0.0 : Wed Nov 15 2006 - 16:22:10 EST