Sql Data Compare Script Servers
5/2/2019 admin
Sql Data Compare Script Servers Rating: 3,6/5 6044 reviews
Full list of features
Sql Studio Data Compare
| 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 |
Choose your SQL Server schema comparison tool. Or you can export the update script to the Transact-SQL editor or to a file. You can also save your comparisons, either as part of your database project or as a stand-alone file. For example, you can compare a SQL Server database structure on a development server to your live SQL Server.