Redgate Data Compare
On
You can then use SQL Data Compare to synchronize the data. To find out more, visit www.red-gate.com. Free ged classes online no costa rica. To see a basic comparison and synchronization, and optionally try it out for yourself, see Synchronizing Data in Two Databases. To see a basic table-level restore and row-level restore from a backup file, see Restoring from a Backup File. Using Redgate SQL Data Compare 9. This is a simplified example of what I want to do. I have the following tables: Product (ProductId, ProductName) ProductDetail (ProductDetailId, ProductId, OtherField) Id columns in both tables are primary keys and auto-increment (identity). Psy gangnam style official video. Product has a unique constraint on ProductName.
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) |
Redgate Data Compare Powershell
| 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 |