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.
Eric
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
