CODEWITHSUNDEEP
sqlsql-serverxmlxml-serialization
Joseph Turian
Joseph Turian

Reputation: 16540

Dump SQL Server to XML?

In mysql, you can use mysqldump --xml to dump to XML.

How do you dump a SQL Server database? Preferably to XML.

Upvotes: 2

Views: 444

Answers (1)

Joe Stefanelli
Joe Stefanelli

Reputation: 135808

You could try the undocumented sp_MSforeachtable command.

EXEC sp_MSforeachtable 'select * from ? for xml auto'

Upvotes: 3

Related Questions