Re : Advices for XML data file transformation

[Laurent ROCHE <la...@yahoo.com>]

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,
L@u
The Computing Froggy

----- Message d'origine ----
De : Thomas Dudziak <to...@gmail.com>
À : ddlutils-user@db.apache.org
Envoyé le : Mercredi, 31 Octobre 2007, 17h06mn 49s
Objet : Re: Advices for XML data file transformation

On 10/30/07, Laurent ROCHE <la...@yahoo.com> 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