Chapter 12. Using XML to transport relational data

Matija Lah

The principal subject of this chapter is the use of XML to transport data between locations. To make the demonstration more interesting, we’ll use XML to transport relational data.

Before we start developing the database solution, we have to analyze and understand our business case. Only after identifying every relevant fact about the business case should you attempt any development work.

In the course of this chapter, through planning and developing activities, we’ll learn the basics of how XML can be used in a Microsoft SQL Server 2005 (or later) database, but not before we touch on some basic truths about the XML standard itself.

Understanding before coding

To make the essence ...

Get SQL Server MVP Deep Dives now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.