In mysql, you can use mysqldump --xml to dump to XML.
How do you dump a SQL Server database? Preferably to XML.
views:
51answers:
1
+3
A:
You could try the undocumented sp_MSforeachtable command.
EXEC sp_MSforeachtable 'select * from ? for xml auto'
Joe Stefanelli
2010-08-18 19:29:12