Microsoft SQL Server Data Portability Documents

The SQL Server Data Portability documents explain various mechanisms by which user-created data in SQL Server can be extracted for use in other software products. These mechanisms include import/export functionality, documented APIs, industry standard formats, or documented data structures/file formats.

These documents are intended for use in conjunction with other Open Specifications documents, SQL Server Books Online content (http://msdn.microsoft.com/en-us/library/bb545450.aspx), and publicly available standard specifications. They assume that the reader either is familiar with this material or has access to it. The SQL Server Data Portability documents provide the following levels of audience support:

Implementer: Information explaining various mechanisms by which user-created data in SQL Server can be extracted for use in other software products to facilitate interoperability.
Reviewer: A resource for readers who want to evaluate or get greater understanding of how Microsoft is approaching its implementation of data portability in Microsoft SQL Server.

Specification	Description
[MS-DPAD]: Alert Definition Data Portability Overview	Provides a data portability scenario for exporting data from the SQL Server Reporting Services Data Alerts feature to a third-party application. Click here to view this version of the [MS-DPAD] PDF.
[MS-DPBACPAC]: Data-Tier Application Schema and Data Data Portability Overview	Provides an overview of exporting and importing data between SQL Server and a vendor's application by using a .bacpac file as a portable artifact. Click here to view this version of the [MS-DPBACPAC] PDF.
[MS-DPBCP]: Bulk Copy Utility Data Portability Overview	Provides an overview of the components and methodologies used for data portability within the SQL Server Engine system. Click here to view this version of the [MS-DPBCP] PDF.
[MS-DPDACPAC]: Data-Tier Application Data Portability Overview	Provides an overview of data portability scenarios for data export and import between SQL Server and a vendor’s application using a data-tier application (DAC) package (a .dacpac file) as a portable artifact. Click here to view this version of the [MS-DPDACPAC] PDF.
[MS-DPDQS]: Data Quality Services Data Portability Overview	Provides an overview of data portability scenarios that use the Microsoft SQL Server Data Quality Services or Management Services client application to export data that is stored in Data Quality Services in a Data Quality Knowledge Base or a data quality project. Click here to view this version of the [MS-DPDQS] PDF.
[MS-DPEDM]: Entity Data Model Data Portability Overview	Provides an overview of data portability for the Entity Data Model (EDM), an entity-relationship model that is used to define an application’s data model. The data model is represented by using entities and the relationships (that is, associations) between those entities. Click here to view this version of the [MS-DPEDM] PDF.
[MS-DPEDMX]: Entity Data Model for Data Services Packaging Format Data Portability Overview	Provides an overview of data portability for an Entity Data Model for the Data Services Packaging Format (EDMX) document. EDMX is an XML-based file format that serves as the packaging format for the service schema of a data service. Click here to view this version of the [MS-DPEDMX] PDF.
[MS-DPIS]: Integration Services Data Portability Overview	Provides an overview of data portability for SQL Server Integration Services (SSIS). SSIS includes a repository for data integration artifacts, including Data Transformation Services packages and Integration Services project deployment files. This repository includes a set of SQL Server tables, views, and stored procedures, depending on the format that is used. Click here to view this version of the [MS-DPIS] PDF.
[MS-DPMDS]: Master Data Services Data Portability Overview	Provides an overview of data portability for Master Data Services (MDS), a Master Data Management (MDM) application that is built from platform components. MDS can be deployed as an application or it can be extended by using these platform components to consistently define and manage the critical data entities of an organization. Click here to view this version of the [MS-DPMDS] PDF.
[MS-DPPDW]: Parallel Data Warehouse Data Portability Overview	Provides an overview of the components and methodologies used for data portability within the SQL Server Parallel Data Warehouse (PDW) system. Click here to view this version of the [MS-DPPDW] PDF.
[MS-DPRDL]: Report Definition Language Data Portability Overview	Provides an overview of data portability for the Microsoft SQL Server Reporting Services Report Definition Language (RDL) system, which includes a repository for RDL documents, such as the Reporting Services report server catalog, or the file system and RDL documents. Click here to view this version of the [MS-DPRDL] PDF.
[MS-DPREP]: Replication Data Portability Overview	Provides an overview of the components and methodologies used for data portability within the SQL Server Replication system. Click here to view this version of the [MS-DPREP] PDF.
[MS-DPSMDL]: Semantic Model Definition Language Data Portability Overview	Provides an overview of data portability for the Microsoft SQL Server Reporting Services Semantic Model Definition Language (SMDL) system, which includes a repository for SMDL documents, such as the Reporting Services report server catalog, or the file system and SMDL documents. Click here to view this version of the [MS-DPSMDL] PDF.
[MS-DPSSAS]: SQL Server Analysis Services Data Portability Overview	Provides an overview of data portability scenarios between Microsoft SQL Server Analysis Services and a vendor’s application. Click here to view this version of the [MS-DPSSAS] PDF.