Updated: July 15, 2020 (December 19, 2016)

SQL Server Data Management Feature Comparison

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

SQL Server provides a variety of data migration and management features as well as event-processing capabilities. The key related SQL Server 2016 SP1 features are shown here by edition.

Feature	Description	Express	Standard	Enterprise
Import/Export Wizard	Migrates data between SQL Server and a variety of predefined data sources in standard formats.	Yes	Yes	Yes
Integration Services	Migrates data between SQL Server and a variety of data sources, and performs data transformation.	No	Yes	Yes
Integration Services— Advanced Adapters and Transforms	Migrates data between SQL Server and many heterogeneous data sources, and performs complex data transformation.	No	No	Yes
R Services	Provides advanced analytic processing and machine learning features, based on the R language.	No	No	Yes
Master Data Services	Provides a single unified data source for reporting and

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now