Ari Maniatis commented on CAY-968:
----------------------------------
If you are using this for testing (and maybe even if you are not), then this is one approach:
> Portable Data with Cayenne - database load/unload feature
> ---------------------------------------------------------
>
> Key: CAY-968
> URL: https://issues.apache.org/cayenne/browse/CAY-968
> Project: Cayenne
> Issue Type: New Feature
> Components: Cayenne Core Library
> Affects Versions: UNDEFINED FUTURE
> Reporter: Michael Bergens
> Assignee: Andrus Adamchik
> Priority: Minor
>
> Here's a dream: I run an ant target or a set of API calls with proper configuration against a database configured with Cayenne, it gives me a set of files or just one file, possibly some compressed archive format such as zip which contain all I need to recreate the same data under the same DBMS or a different one. So whenever needed, I can send this file or files to a colleague who would run a reverse ant target (or a set of API calls) and have the same database ready for use in the DBMS of his choice.
> Cayenne has plenty of good stuff which would make this possible and my team is currently implementing subset of this functionality tailored to our specifics: it requires some manual effort on the part of indicating the sequence in which the tables should be loaded, manual adjustment of primary key generation info after loading a table etc. Would be good to have this implemented in a core or an optional extension. The portable format should be versionable plain text such as XML or JSON - that would allow me to to use the VCS to keep my test data, demo data etc, properly versioned.
-- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
This archive was generated by hypermail 2.0.0 : Mon Jan 21 2008 - 01:43:07 EST