db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Emminger <e...@ericemminger.com>
Subject Re: generate data migration scripts
Date Sat, 22 Mar 2003 17:21:01 GMT
Phillip, Jim

> 1. Query database 1 and store the results in XML
> 2. Write an XSLT file to transform the XML results from database 1 into 
> XML valid for database 2 (depending on the differences between the two, 
> that may or may not be a lot of hand-coding).
> 3. Transform the database 1 XML into database 2 XML
> 4. Insert the new XML into database 2

I'm currently doing most of this. It seems like the best option so far. 
I use Castor to go between the database and XML. Step 4 does work! I 
also wrote a simple utility to generate a Castor mapping file from your 
Torque schema.xml file. I'd be happy to contribute it to Torque if you 
want it.


View raw message