export all database data to xml format with SQL Server 2008

Question

I have .bak format file with database from another company. After a long time of configuration SQL Server I have access to this data but Is there any way to export all database to XML format? Is there easiest way than export every table by typing:

SELECT * from MLS.dbo.Offers

FOR XML AUTO

ViKiNG · Accepted Answer · 2017-07-19 21:32:07Z

1

Not an exact answer but following SQL will help you to list down all the schema and table names. And you can build a dynamic SQL thing around this result set to achieve what you want.

SELECT DISTINCT
       DB_NAME() AS [Database],
       SCHEMA_NAME(SCHEMA_ID) AS [Schema],
       Name AS [Table]
FROM sys.tables
ORDER BY 1,2;

answered Jul 19, 2017 at 21:32

ViKiNG

1,3342 gold badges20 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

export all database data to xml format with SQL Server 2008

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related