Editions and supported features of SQL Server 2016 • • 16 minutes to read • Contributors • • • • • • In this article APPLIES TO: SQL Server (starting with 2016) Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse This topic provides details of features supported by the SQL Server editions. At this time there are no changes to features supported by editions for SQL Server 2017.

Installation requirements vary based on your application needs. The different editions of SQL Server accommodate the unique performance, runtime, and price requirements of organizations and individuals. The SQL Server components that you install also depend on your specific requirements.

Sql Server Data Comparison

Data Comparison Tool

DbForge Data Compare for SQL Server finds data differences in Source and Target SQL Server database tables. Source is a database, the content of which is inserted into Target after synchronization. SQL Server data comparison tools are responsible for comparing the values between 2 or more tables in separate databases and synchronizing the values. These applications typically have a straight forward interface to synchronize the data or to build a script which can complete the synchronization.

Sql Server Data Comparison

The following sections help you understand how to make the best choice among the editions and components available in SQL Server. The SQL Server Evaluation edition is available for a 180-day trial period. For the latest release notes and what's new information, see the following: • • • • Try SQL Server! SQL Server Editions The following table describes the editions of SQL Server.

Sql Server Data Comparison Tool

SQL Server edition Definition Enterprise The premium offering, SQL Server Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization, and end-to-end business intelligence - enabling high service levels for mission-critical workloads and end user access to data insights. Standard SQL Server Standard edition delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premise and cloud - enabling effective database management with minimal IT resources. Web SQL Server Web edition is a low total-cost-of-ownership option for Web hosters and Web VAPs to provide scalability, affordability, and manageability capabilities for small to large scale Web properties. Developer SQL Server Developer edition lets developers build any kind of application on top of SQL Server. It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server. SQL Server Developer is an ideal choice for people who build SQL Server and test applications. Express editions Express edition is the entry-level, free database and is ideal for learning and building desktop and small server data-driven applications.