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.
To make the essence ...