how to convert sql server 2008 database to its xml form? -


I have a database in SQL Server 2008. I want to convert it to XML format. what I have to do? what is the procedure ? Please guide me. I do not want to write code for this in any language. Is there any feature in SQL Server 2008?

Take a look at this solution here:

This is a resultset for XML It uses an archived method to export it, it is an old article, but it is possible to check it out. I have not tested it so your mileage may vary.

From the site:

  You create a file with the first text-editor like: & lt; Root & gt; & Lt;% beginindetail% & gt; & Lt;% insert_data_here% & gt; & Lt;% enddetail% & gt; & Lt; / Root & gt; Save it as c: \ temp \ template.tpl, you open QA and type: sp_makewebtask @outputfile = 'c: \ temp \ myxmlfile.xml', @query = 'select from sysobjects for XML', @templatefile = 'C: \ temp \ template.tpl' result is an XML-file!  

Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -