Post reply

Extract XML From SQL

  • March 6, 2012 at 2:14 am

    #98622

    I have inherited a system which is a SQL Database which stores XML data in a Text Column.

    I have an exe which extracts the data into xml Files and then re-imports using SSIS into a relational format.

    I have schema files (xsd) but would like to ideally import the data directly into a relational format without the need to export (especially as I need to add more data and the exe is uneditable).

    I have no real xml experience, so the simpler solution the better.

    Any thoughts on the best way?

    Thanks.

  • March 6, 2012 at 8:20 am

    #1455355

    The standard term is "shredding XML".

    You first need to be familiar with XPath and XQuery. You can find tutorials on the web. Once you feel comfortable with those, you can look up "shredding XML". If you're still having problems at that point, feel free to come back and post with what you have tried.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA

  • March 7, 2012 at 2:34 pm

    #1456259

    T-SQL is pretty slow at parsing / shredding XML, so you will probably find that it is better to use an exe for that. You could even make it part of the SQL by using a CLR.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply