SQL Server Data Portability Technical Documents

This section provides information about the data portability technical documents that are contained in the Microsoft SQL Server Data Portability documentation set.

Note The inter-document links in a PDF version of a technical document are functional only if all the cross-referenced documents are saved to the same local directory folder. An error message appears if you click a link that references a PDF document that is not located in the same folder (when viewing via your local hard drive) or is part of a different download (when viewing online). To save a complete set of PDF files to the same folder, download the SQL Server Data Portability .zip file.

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 by 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 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 the Entity Data Model Extensions for 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 (DTS) packages and Integration Services (IS) project deployment files. This repository includes a set of SQLServer 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 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 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 SQL Server Analysis Services and a vendor's application.

Click here to view this version of the [MS-DPSSAS] PDF.