SQL Data Compare Pro - 概要

概要 | 価格及びライセンス | 試用版とそのダウンロード | 互換性 | 開発元詳細 | 結果

結果

SQL Data Compare Pro by Red Gate Software

Compares and synchronizes SQL database contents. SQL Data Compare is used by thousands of Database Administrators (DBAs), developers and testers worldwide. SQL Data Compare is used when the data between two databases has got out of synch, and saves huge amounts of tedious work in synchronizing them. Others use it as a tool for QA, documentation and verification. With SQL Data Compare you can compare the contents of two databases, automatically synchronize your data. With SQL Data Compare Pro you can compare database backup files as if they were live databases and do row-level data restores. SQL Data Compare fully supports SQL Server 2008.

SQL Data Compare Pro is used for automating data migrations, analyzing corrupted data, restoring row-level data from backups and compiling audit trails of missing or changed data. It is one of the industry standard tools for comparing and synchronizing the contents of two databases because it is very reliable and also veryfast.

With SQL Data Compare's granular SQL change-scripts you can now restore damaged or missing data to a single row, without the need for a full database recovery, and that means you can fix database problems even faster.

With SQL Data Compare Pro, you can compare and synchronize SQL Server live databases with backups or simply compare two backups. With the command line interface you can automate tasks and schedule comparisons for easy compilation of an audit trail.

Find out when and how your data changed by comparing directly to backups. SQL Data Compare will save you many hours which you would otherwise spend copying, restoring and comparing databases with backups by hand; moreover, you can specify exactly which tables, rows, and columns from your databases you want to synchronize.

Some of the things SQL Data Compare can do for you:

Verify the success of your data migration

Create an audit trail by comparing backups

Restore missing or damaged data at table, row or column level

Troubleshoot your replication issues

Migrate data seamlessly between SQL Server 2000, 2005 and 2008

Provide an essential QA and documentation tool

Display row-data in columns (Pivot-view) for faster difference analysis

Run automated backups before synchronization

Optional compression of temporary files for improved performance

For comparing and synchronizing database schemas, check out SQL Data Compare's companion product, SQL Compare.

Feature list:

Comparison and synchronization of Microsoft SQL Server databases (2000 - 2008), eliminating hours of tedious, manual work.

Comparison with backups – native and compressed backup formats of SQL Server 2008 in addition to the backup files of SQL Server 2000 and 2005, and Red Gate's SQL Backup (Pro edition).

Fast Row Level Restore of damaged or missing data (Pro edition).

Full support for SQL Server 2008, including spatial, temporal and hierarchy data types, sparse columns, and new collations.

Full support for SQL Server 2005, including string into XML or CLR data type transformations and CLR, DDL and DML triggers.

Comparison on primary keys and unique indexesso you have the flexibility to define identical rows.

Custom comparison keys so you can compare databases based on any field – and it doesn't even need to be unique!

Support for indexed views so you can view data differences on views as well as tables.

'Pivot-view' difference navigation displays row data as columns for rapid identification and selection of data for synchronization.

Comparison and synchronization of large databases– works on databases with thousands of tables and gigabytes of data.

Simple to use and hides complexity from the user. Once the comparison has been completed, a script is automatically generated.

Integrates with SQL Query Analyzer or SQL Server Management Studio.

Option to transport CLR data types as text or binary for increased speed.

Mapping allowing you to compare tables, views, or even whole schemas, with different naming allowing for total flexibility.

PartNumbers: PC-516296-169477 516296-169477 PC-516296-169478 516296-169478 PC-516296-169479 516296-169479 PC-516296-169480 516296-169480 PC-516296-169481 516296-169481 PC-516296-169482 516296-169482 PC-516296-169483 516296-169483 PC-516296-169484 516296-169484 PC-516296-169485 516296-169485 PC-516296-169486 516296-169486 PC-516296-169487 516296-169487 PC-516296-169488 516296-169488 PC-516296-169489 516296-169489 PC-516296-169490 516296-169490 PC-516296-169491 516296-169491 PC-516296-169492 516296-169492 PC-516296-169493 516296-169493 PC-516296-169494 516296-169494 PC-516296-169495 516296-169495 PC-516296-169496 516296-169496 PC-516296-169497 516296-169497

Publisher PartNumbers: P50U10M0 P50U10M12 P50U10M24 P50U10M36 P50U1M0 P50U1M12 P50U1M24 P50U1M36 P50U5M0 P50U5M12 P50U5M24 P50U5M36

PurchaseOptions: SQL Data Compare Pro V7.1 1 User License , SQL Data Compare Pro V7.1 5 User License , SQL Data Compare Pro V7.1 10 User License , SQL Data Compare Pro V7.1 with 12 Months of Support and Upgrades 1 User License , SQL Data Compare Pro V7.1 with 12 Months of Support and Upgrades 5 User License , SQL Data Compare Pro V7.1 with 12 Months of Support and Upgrades 10 User License , SQL Data Compare Pro V7.1 with 24 Months of Support and Upgrades 1 User License , SQL Data Compare Pro V7.1 with 24 Months of Support and Upgrades 5 User License , SQL Data Compare Pro V7.1 with 24 Months of Support and Upgrades 10 User License , SQL Data Compare Pro V7.1 with 36 Months of Support and Upgrades 1 User License , SQL Data Compare Pro V7.1 with 36 Months of Support and Upgrades 5 User License , SQL Data Compare Pro V7.1 with 36 Months of Support and Upgrades 10 User License , SQL Data Compare Pro V7.1 Renewal License - 12 Months of Support and Upgrades 1 User Renewal License , SQL Data Compare Pro V7.1 Renewal License - 12 Months of Support and Upgrades 5 User Renewal License , SQL Data Compare Pro V7.1 Renewal License - 12 Months of Support and Upgrades 10 User Renewal License , SQL Data Compare Pro V7.1 Renewal License - 24 Months of Support and Upgrades 1 User Renewal License , SQL Data Compare Pro V7.1 Renewal License - 24 Months of Support and Upgrades 5 User Renewal License , SQL Data Compare Pro V7.1 Renewal License - 24 Months of Support and Upgrades 10 User Renewal License , SQL Data Compare Pro V7.1 Renewal License - 36 Months of Support and Upgrades 1 User Renewal License , SQL Data Compare Pro V7.1 Renewal License - 36 Months of Support and Upgrades 5 User Renewal License , SQL Data Compare Pro V7.1 Renewal License - 36 Months of Support and Upgrades 10 User Renewal License

Resources: Read the SQL Data Compare Data sheet, Read the SQL Compare Data sheet, Read the SQL Compare Database Development White Paper, Read the Red Gate End User License Agreement, Download the SQL Toolbelt evaluation on to your computer - Expires after 14 days

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000

Architecture of Product: 32Bit

Product Type: Application

Compatible Containers: Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server 2000

Keywords: Database DB Reporting Report reports SQL query language Red Gate Software Red-Gate RedGate Database DB Management Verification Verify verified Check Checking Professional Partner Data Compare sql synchronize synchronization data database structure development replication replicate SQL SQL standard query language database databases querying queries access server redgate