I see so the trick will be to use the model from database B to run an export on database A. I was also thinking of using XSLT to transform XML.
Have fun, [EMAIL PROTECTED] The Computing Froggy ----- Message d'origine ---- De : Thomas Dudziak <[EMAIL PROTECTED]> À : [email protected] Envoyé le : Mercredi, 31 Octobre 2007, 17h06mn 49s Objet : Re: Advices for XML data file transformation On 10/30/07, Laurent ROCHE <[EMAIL PROTECTED]> wrote: > I am a complete novice to XML (I have used it and understand if but I have never programmed anything with it). > > I am now in the case where I am doing an export of data (using ddl-utils) from database A and I need to import the data into database B. > However, tables in database A have extra columns (the last 3, identical in all tables) that are not present in database B. > > How do I achieve this ? > > Can DdlUtils do that on its own ? (Can I export data without the last 3 columns, that will be the best option as the files generated will be smaller) > Do I need to modify the XML file generated with a (Java) program ? DdlUtils will export the tables and columns that are in the database model that you give it. This means that if the model for database A that you use to export the data, does not contain these columns, then DdlUtils won't export them. You can also adjust the data XML file using for instance XSLT, which basically defines a transformation XML -> XML. In this XSLT 'script' you simply ignore the XML attribute values that correspond to these columns. Tom _____________________________________________________________________________ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
