Using XSLT for complicated database mapping

[Noam Rotem <noamr@xxxxxxxxxxxxxxxxx>]

I have two relational databases, based on complicated schemas. The
organization of data within each is completely different, but logically it
is possible to map data from one database to another. Some special cases I
can already point out:

1. One row of the source is mapped into two rows of the destination, with
relations between them (i.e. - a unique key must be generated and planted on
the fly)
2. Two rows are combined into one on the destination database.
3. A row is mapped according to a list of if else tests
4. A row is not mapped at all, due to a certain mapping rule
5. Keys of one database do not fit the masking methods of the other, so keys
must be changed following some generation rules before data is inserted into
the target database.


Can you tell me whether XSL(T) solves these transformation problems
(provided that I export database data into XML format, of course)? Also, can
you point out some good reference for this particular issue?

Thanks in advance,

Noam Rotem



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list