Sql Server Compare Table Data 8,7/10 2331 votes
Compare Microsoft SQL Server versions
- Not supported
- Fully supported
Performance features of SQL Server by SQL Server version| Features | SQL Server 2017 | SQL Server 2016 | SQL Server 2014 | SQL Server 2012 | SQL Server 2008 R2 |
|---|
| In Memory OLTP |
|---|
| In-Memory ColumnStore |
|---|
| Real Time Operational Analytics |
|---|
| Buffer Pool extension to SSD |
|---|
| Adaptive Query Processing[1] |
|---|
Availability features of SQL Server by SQL Server version| Features | SQL Server 2017 | SQL Server 2016 | SQL Server 2014 | SQL Server 2012 | SQL Server 2008 R2 |
|---|
| Always On[1] |
|---|
| Basic Availability Groups |
|---|
Security features of SQL Server by SQL Server version| Features | SQL Server 2017 | SQL Server 2016 | SQL Server 2014 | SQL Server 2012 | SQL Server 2008 R2 |
|---|
| Transparent data encryption[1] |
|---|
| Backup encryption support |
|---|
| Encryption at rest and in motion |
|---|
| Dynamic Data Masking and Row Level Security |
|---|
| Separation of duties |
|---|
Cloud-readiness features of SQL Server by SQL Server version| Features | SQL Server 2017 | SQL Server 2016 | SQL Server 2014 | SQL Server 2012 | SQL Server 2008 R2 |
|---|
| Backup to Azure |
|---|
| Disaster recovery to Microsoft Azure |
|---|
| Optimized virtual machine images in Azure gallery |
|---|
| Stretch Database |
|---|
Management and programmability features of SQL Server by SQL Server version| Features | SQL Server 2017 | SQL Server 2016 | SQL Server 2014 | SQL Server 2012 | SQL Server 2008 R2 |
|---|
| Runs on Linux and Docker Containers |
|---|
| Temporal tables |
|---|
| JSON support |
|---|
| Graph data support |
|---|
BI and analytics features of SQL Server by SQL Server version| Features | SQL Server 2017 | SQL Server 2016 | SQL Server 2014 | SQL Server 2012 | SQL Server 2008 R2 |
|---|
| Integration services managed as a server |
|---|
| PolyBase for T-SQL query across Hadoop |
|---|
| Tabular BI semantic model[1] |
|---|
| Master data services[1] |
|---|
| Data quality services[1] |
|---|
| In-database advanced analytics |
|---|
| End-to-end Mobile BI on any device |
|---|
| Features | SQL Server 2017 | SQL Server 2016 | SQL Server 2014 | SQL Server 2012 | SQL Server 2008 R2 |
|---|
| Features | SQL Server 2017 | SQL Server 2016 | SQL Server 2014 | SQL Server 2012 | SQL Server 2008 R2 |
|---|
| Features | SQL Server 2017 | SQL Server 2016 | SQL Server 2014 | SQL Server 2012 | SQL Server 2008 R2 |
|---|
| Features | SQL Server 2017 | SQL Server 2016 | SQL Server 2014 | SQL Server 2012 | SQL Server 2008 R2 |
|---|
Full list of features
| What can I compare and synchronize? | Standard | Pro |
|---|
| SQL Server 2005, 2008, 2012, 2014, 2016, SQL Azure, & SQL Server on Amazon RDS databases |
| Native, encrypted, & compressed SQL Server 2005, 2008, & 2012 backup files |
| SQL Server 2014 backup files |
| Redgate SQL Backup Pro files |
| Folders of SQL scripts (for source control) |
| Features | Standard | Pro |
|---|
| Compare and deploy changes to SQL Server database contents |
| Compare and synchronize data from within SSMS |
| Automatically create error-free synchronization scripts |
| Build sophisticated rules to selectively limit what to synchronize |
| Index view support so data differences are seen on both views and tables |
| Comparison on primary keys and unique indexes so you can define identical rows |
| Custom comparison keys to compare databases based on any field |
| Pivot-view difference navigation to display row data as columns |
| Comparison and synchronization of large databases |
| Create an audit trail by comparing backups |
| Backup target database before changes are migrated |
Command line automation
(If you're using the command line on a build server, youll need SQL Change Automation) |
| Fast table, column, or row level restore of damaged or missing data |