Bild von SQL Data Compare

SQL Data Compare

von Red Gate

SQL Data Compare vergleicht und synchronisiert Daten

SQL Data Compare

SQL Data Compare vergleicht und synchronisiert Daten

  • Zeitsparen beim Vergleichen und Synchronisieren von Daten
  • Generiert T-SQL Skripte um eine Datenbank mit den Inhalten einer anderen zu aktualisieren
  • Schnelle Problembehebung
  • Aufbewahrung einer exakten Historie aller bisherigen Datenbankaufzeichnungen
  • Vergleicht und synchronisiert Daten mit SSMS

SQL Data Compare is the industry-standard tool for comparing and deploying SQL Server database contents.

You can work with live databases, backups, or SQL scripts in source control. With the command line interface you can automate tasks and schedule comparisons to easily create an audit trail. Damaged or missing data can be restored to a single row, without the need for a full database recovery.

SQL Data Compare helps you compare and deploy changes quickly, simply, and with zero errors.

Do all this with SQL Data Compare Standard

  • Save time comparing and synchronizing data
  • Copy lookup data from development databases to staging or production
  • Generate T-SQL scripts to update one database with the contents of another
  • Keep an accurate history of all previous database records
  • Compare and synchronize data from within SQL Server Management Studio
  • Deploy to SQL Server, SQL Azure, and SQL Server on Amazon RDS

Do even more with SQL Data Compare Pro

  • Quickly fix problems by restoring damaged or missing data to a single row
  • Deploy databases from source control
  • Compare and synchronize from backup files
  • Command line automation
  • Run SQL Data Compare on your build server for continuous integration (with the SQL Automation Pack)

Full list of features

What can I compare and synchronise?StandardPro
SQL Server 2005, 2008, 2012, 2014, 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)  
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 on your local dev machine (If you're using the command line on a build server, you'll need the SQL Automation Pack)  
Fast table, column, or row level restore of damaged or missing data  
Artikelnummer Bezeichnung Upg Mon. Nettopreis Bruttopreis
154432 SQL Data Compare Pro, 1 User, 1 Jahr Maintenance Verlängerung eng. Win. User Pack 12 €127,73 €152,00
154252 SQL Data Compare, 1 User, 1 Jahr Maintenance Verlängerung eng. Win. User Pack 12 €84,96 €101,10
152812 SQL Data Compare Pro, 1 User, Lizenz inkl. 1 Jahr Maintenance eng. Win. User Pack 12 €640,34 €762,00
152632 SQL Data Compare, 1 User, Lizenz inkl. 1 Jahr Maintenance eng. Win. User Pack 12 €424,37 €505,00
116969 SQL Data Compare Pro, 10 User, 1Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 12 €5097,48 €6066,00
116970 SQL Data Compare Pro, 10 User, 1Y, EN, WIN, MNT User Pack, Gesamtpreis 12 €1016,81 €1210,00
116971 SQL Data Compare Pro, 10 User, 2Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 24 €6115,13 €7277,00
116972 SQL Data Compare Pro, 10 User, 2Y, EN, WIN, MNT User Pack, Gesamtpreis 24 €2034,45 €2421,00
116973 SQL Data Compare Pro, 10 User, 3Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 36 €7131,09 €8486,00
116974 SQL Data Compare Pro, 10 User, 3Y, EN, WIN, MNT User Pack, Gesamtpreis 36 €3051,26 €3631,00
116975 SQL Data Compare Pro, 5 User, 1Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 12 €2704,20 €3218,00
116976 SQL Data Compare Pro, 5 User, 1Y, EN, WIN, MNT User Pack, Gesamtpreis 12 €539,50 €642,00
116977 SQL Data Compare Pro, 5 User, 2Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 24 €3242,86 €3859,00
116978 SQL Data Compare Pro, 5 User, 2Y, EN, WIN, MNT User Pack, Gesamtpreis 24 €1077,31 €1282,00
116979 SQL Data Compare Pro, 5 User, 3Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 36 €3781,51 €4500,00
116980 SQL Data Compare Pro, 5 User, 3Y, EN, WIN, MNT User Pack, Gesamtpreis 36 €1615,13 €1922,00
116981 SQL Data Compare, 10 User, 1Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 12 €3389,92 €4034,00
116982 SQL Data Compare, 10 User, 1Y, EN, WIN, MNT User Pack, Gesamtpreis 12 €669,75 €797,00
116983 SQL Data Compare, 10 User, 2Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 24 €4056,30 €4827,00
116984 SQL Data Compare, 10 User, 2Y, EN, WIN, MNT User Pack, Gesamtpreis 24 €1340,34 €1595,00
116985 SQL Data Compare, 10 User, 3Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 36 €4726,05 €5624,00
116986 SQL Data Compare, 10 User, 3Y, EN, WIN, MNT User Pack, Gesamtpreis 36 €2010,08 €2392,00
116987 SQL Data Compare, 5 User, 1Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 12 €1800,84 €2143,00
116988 SQL Data Compare, 5 User, 1Y, EN, WIN, MNT User Pack, Gesamtpreis 12 €358,82 €427,00
116989 SQL Data Compare, 5 User, 2Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 24 €2159,66 €2570,00
116990 SQL Data Compare, 5 User, 2Y, EN, WIN, MNT User Pack, Gesamtpreis 24 €717,65 €854,00
116991 SQL Data Compare, 5 User, 3Y, EN, WIN, LIZ+MNT User Pack, Gesamtpreis 36 €2518,49 €2997,00
116992 SQL Data Compare, 5 User, 3Y, EN, WIN, MNT User Pack, Gesamtpreis 36 €1077,31 €1282,00