Full list of features

What can I compare and synchronize?StandardPro
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)

You can stop a data comparison operation that is in progress by opening the SQL menu, clicking Data Compare, and then clicking Stop Data Comparison. When the comparison is finished, you can view the data differences between the two databases. May 08, 2017  Compare two databases for objects differences This SQL script will compare table columns, Index and foreign keys in two databases. This will show a result with missing objects and the objects with definition mismatch. Hi All, I wan't to compare two SQL Server databases. I.e., I wan't to check both databases structure and add if necessary. In my project I am using SQL Express database and now we update some fields in the database.

FeaturesStandardPro
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

Compare Microsoft SQL Server versions

Feature availability
  • Not supported
  • Fully supported
Performance features of SQL Server by SQL Server version
FeaturesSQL Server 2017SQL Server 2016SQL Server 2014SQL 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
FeaturesSQL Server 2017SQL Server 2016SQL Server 2014SQL Server 2012 SQL Server 2008 R2
Always On[1]
Basic Availability Groups
Security features of SQL Server by SQL Server version
FeaturesSQL Server 2017SQL Server 2016SQL Server 2014SQL 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
FeaturesSQL Server 2017SQL Server 2016SQL Server 2014SQL 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
FeaturesSQL Server 2017SQL Server 2016SQL Server 2014SQL 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
FeaturesSQL Server 2017SQL Server 2016SQL Server 2014SQL 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
FeaturesSQL Server 2017SQL Server 2016SQL Server 2014SQL Server 2012 SQL Server 2008 R2
FeaturesSQL Server 2017SQL Server 2016SQL Server 2014SQL Server 2012 SQL Server 2008 R2
FeaturesSQL Server 2017SQL Server 2016SQL Server 2014SQL Server 2012 SQL Server 2008 R2
FeaturesSQL Server 2017SQL Server 2016SQL Server 2014SQL Server 2012 SQL Server 2008 R2