Re: Importing XML

[Quoted] If it was Oracle only, XSU (XML SQL Utility) could be of help, but since your requirement includes mssql target, the best approach I can think of is creating an XSLT stylesheet that will convert your source XML document into a document consisting of series of inserts. You then use any parser which supports XSLT and specify the stylesheet to get the result document. Not sure there are tools out there that can build such stylesheet automagically though.

--
Vladimir Zakharychev (bob_at_dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"Peter Lowe" <peterlowebris_at_hotmail.com> wrote in message news:b58onl$833$1_at_gnamma.connect.com.au...


> I have an XML file containing data that I need to get into a Database, and


> then massage it to merge with existing data.

>

> Does anybody know of any tools out there where I can do this easily?

>

> I need the data for both SQL Server and Oracle databases.  I am thinking

> that I would be best to rearrange the data as INSERT statements which I can

> then run in Query Analyser or SQL Plus.

>

> Thanks,

> Peter.

>

>

>