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.
On 11/15/06, Øyvind Harboe <[EMAIL PROTECTED]> wrote:
On 11/15/06, Andreas Hjortsberg <[EMAIL PROTECTED]> wrote: > Hello again, > > I been looking around in the docs for some kind of solution to resolve foreign keys during > the very handy DataPort.execute(), or sort the entitys before that? I'm not sure DataPort is meant to solve foreign key problems or more generally to be a robust, generic and scalable solution for converting between arbitrary databases where the source database is possibly corrupt. Isn't DataPort rather an example of something that can be modified to do what one needs? Some problems: http://www.objectstyle.org/cayenne/lists/cayenne-user/2006/06/0173.html http://www.objectstyle.org/cayenne/lists/cayenne-user/2006/06/0160.html http://www.objectstyle.org/cayenne/lists/cayenne-user/2006/06/0103.html For our project I've mangled dataport to do my dirty deeds(e.g. handling duplicate!! primary keys, etc.). -- Øyvind Harboe http://www.zylin.com
