Share via

2.2 Import Data

  • Article

The data import scenario describes importing vendor's data to a .dacpac file so that the data can be deployed to Microsoft SQL Server as a data-tier application. As shown in the following figure, a vendor can produce XML parts that conform to [MS-DACPAC] structure format and package it to a .dacpac file. Note that the vendor is required to implement the methodology producing the XML parts within the vendor's application.

Import data

Figure 3: Import data

A vendor can package the XML parts to a .dacpac file by using the API that is specified in System.IO.Packaging [MSDN-SIOPN] and can deploy the .dacpac file to SQL Server by using the DAC API. To create a .dacpac file that can be deployed to SQL Server, a vendor's .dacpac file is required to contain dacmetadata.xml, logicalobjectstream.xml, physicalobjectstream.xml, and, optionally, targetselection.xml.