Copying objects from one database to another

From: jerome moliere (jerome.molier..mail.com)
Date: Tue Apr 17 2007 - 11:14:38 EDT

  • Next message: Michael Gentry: "Re: Copying objects from one database to another"

    Hi all,
    this is my question of the day (waiting for the tip of the day andrus -) )

    Let's imagine a database db1 with a catalog1, schema 1 containing table T1
    mapped as p1.T1 with Cayenne
    db2 (catalog2,schema2) containing same T1 table mapped as p2.T1 with Cayenne

    db1 and db2 live on the same machine
    I'd like to make copies from some db1 entities to db2 in a transactional
    fashion without requiring XA transactions..
    Is it possible ? I've seen one sample with quite this requirement but I 'd
    like to be sure for the good practice to do that

    Concrete usage for this ?
    Storing an entire database: customizing reference data for any customer or
    versioning objects...

    Thanks in advance
    Jerome 

    -- 
Jerome Moliere - Mentor/J
http://romjethoughts.blogspot.com/
auteur Eyrolles

    This archive was generated by hypermail 2.0.0 : Tue Apr 17 2007 - 11:15:34 EDT