I know that in MYSQL you can do a mysqldump to xml.

MySQL :: MySQL 5.1 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program

I don't know if there is something similar in MSSQL.
...