use XML schema to prepare XML file from a table data

  • I have an XML schema. The data for preparing an XML file is in a table. Is there a way in SSMS to use XML schema on a table or view, something like mapping the columns to XML elements? So that it would export the data in a correctly formatted XML file? (I could bring the data to a newer version of  an SQL server from SQL server 2008 if any of the newer versions support something like this...)

  • sani.bozic - Thursday, December 20, 2018 1:36 PM

    I have an XML schema. The data for preparing an XML file is in a table. Is there a way in SSMS to use XML schema on a table or view, something like mapping the columns to XML elements? So that it would export the data in a correctly formatted XML file? (I could bring the data to a newer version of  an SQL server from SQL server 2008 if any of the newer versions support something like this...)

    No
    😎

  • Thank you for a to the point reply. I was kind of hoping...

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

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