2

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

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

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Joseph Turian
  • 15,430
  • 14
  • 47
  • 62

1 Answers1

3

You could try the undocumented sp_MSforeachtable command.

EXEC sp_MSforeachtable 'select * from ? for xml auto'
Joe Stefanelli
  • 132,803
  • 19
  • 237
  • 235
  • 1
    Where is the dump file being created, or how can I define the output? I run the command in MS SQL Server Mgmt Studio Express, and get a message "Command(s) completed successfully", but that's it. Thanks. – Mathias Conradt May 10 '12 at 07:35