[JIRA] Created: (CAY-968) Portable Data with Cayenne - database load/unload feature

From: Michael Bergens (JIRA) ("Michael)
Date: Sun Jan 20 2008 - 17:55:33 EST

  • Next message: Michael Bergens (JIRA): "[JIRA] Created: (CAY-969) Need ability to break data maps into multiple XML files (on entity by entity basis)?"

    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 : Sun Jan 20 2008 - 17:55:57 EST