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:[EMAIL PROTECTED] To: [email protected] Sent: Wed, 15 Nov 2006 21:44:01 +0100 Subject: Re: DataPort > On 11/15/06, Mike Kienenberger <[EMAIL PROTECTED]> 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 > >
