- Joined
- Aug 24, 2006
- Messages
- 109,681
- Likes received
- 22,970
- Thanks received
- 7,628
Does the XML need to conform to an XSD schema?
Or can it be any XML, as long as it's valid XML?
Because if it's just any XML, simply put
for xml auto
on the end of any queries and then save the string.
Cheers for the response.
It does need to correspond to a schema.
Formatting the sql select to the xml string required is a huge pain. I thought there might be some tools out there to help - though maybe this is a niche requirement.
Plan C maybe.....
Any good tools for generating xml getting data from a database?
This is SQL Server. I am looking at using tsql commands.
It is clearly doable - though sqlserver has some interesting considerations(duplicate rows etc.)
SSIS seems to have nothing useful.