by Red Gate Software - 상품타입: 어프리케이션
SQL Data Compare by Red Gate Software
URLs: red-gate-sql-data-compare-standard, red gate sql data compare standard, redgatesqldatacomparestandard, red-gate, red gate, redgate
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. SQL Data Compare fully supports SQL Server 2008.
SQL Data Compare 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.
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.
What's New in SQL Data Compare 10.0
Select a version of your database from source control
Recently used server list and recently accessed repository list
Fast Deploy - two-click deploy from the project list for common deployments
Major Feature Requests Implemented / Bugs Fixed
SDC-113 - New option to compare null values as equal to empty strings
SDC-206 - New option to compare floats that only have unsynchronizable differences as equal
SDC-1137 - Viewer now correctly displays full length of float values
SDC-1293 - int datatypes can now successfully map to varchar and some other string types
SDC-1304 - Command line help can now be written to a file with /out
SDC-1290 - Handling of unusual unicode values in varchar(max) blobs improved
SDC-1301 - UTF-8 script encoding option now no longer writes preamble by default
What's New in SQL Data Compare 9
SQL Data Compare 9.0 now supports SQL Azure databases.
SQL Data Compare 8.0 introduces the following features:
The ability to store static data in scripts folders
SQL Data Compare 8 allows you to store data scripts in a scripts folder, making it easier to keep databases under source control.
The ability to share projects with SQL Compare
To open a SQL Data Compare project in SQL Compare, on the Projects dialog box, select a project, right click, and click Launch in SQL Compare.
Alternatively, to open the current project in SQL Compare, click the SQL Compare icon on the toolbar of the main window.
You can open a SQL Compare 8.1 (or later) project in SQL Data Compare 8.0 or later.
You can open a SQL Data Compare 8.0 (or later) project in SQL Compare 8.1 or later.
Multiple transactions in the synchronization script
In previous versions, the synchronization can be enclosed in a single transaction. This allows rollback, but can result in poor performance for large databases. In SQL Data Compare 8.0 you have the option to use multiple transactions. You can specify the amount of data included in each transaction using the Application Options.
User interface refinements
SQL Data Compare 8.0 includes many of the user interface improvements made for SQL Compare 8, bringing the workflow of the two products closer together.
Command line changes
The command line interface now supports column-level inclusion and exclusion. There are changes to the behaviour of some existing switches and options.
Stability and performance improvements
SQL Data Compare 8.0 addresses some known stability issues. There are now fewer Out of memory errors when comparing large databases.
Compares and synchronizes SQL database contents.
Pricing: SQL Data Compare 10.1 with 12 Months of Support and Upgrades 1 User License, SQL Data Compare 10.1 with 12 Months of Support and Upgrades 5 User License, SQL Data Compare 10.1 with 12 Months of Support and Upgrades 10 User License, SQL Data Compare 10.1 with 24 Months of Support and Upgrades 1 User License, SQL Data Compare 10.1 with 24 Months of Support and Upgrades 5 User License, SQL Data Compare 10.1 with 24 Months of Support and Upgrades 10 User License, SQL Data Compare 10.1 with 36 Months of Support and Upgrades 1 User License, SQL Data Compare 10.1 with 36 Months of Support and Upgrades 5 User License, SQL Data Compare 10.1 with 36 Months of Support and Upgrades 10 User License, SQL Data Compare 10.1 Renewal License - 12 Months of Support and Upgrades 1 User Renewal License, SQL Data Compare 10.1 Renewal License - 12 Months of Support and Upgrades 5 User Renewal License, SQL Data Compare 10.1 Renewal License - 12 Months of Support and Upgrades 10 User Renewal License, SQL Data Compare 10.1 Renewal License - 24 Months of Support and Upgrades 1 User Renewal License, SQL Data Compare 10.1 Renewal License - 24 Months of Support and Upgrades 5 User Renewal License, SQL Data Compare 10.1 Renewal License - 24 Months of Support and Upgrades 10 User Renewal License, SQL Data Compare 10.1 Renewal License - 36 Months of Support and Upgrades 1 User Renewal License, SQL Data Compare 10.1 Renewal License - 36 Months of Support and Upgrades 5 User Renewal License, SQL Data Compare 10.1 Renewal License - 36 Months of Support and Upgrades 10 User Renewal License
Evals & Downloads: Read the SQL Data Compare help file, 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: MS SQL Azure, Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server 2000
Keywords: sql data compare std, sql data compare standard, red gate data compare std, redgate data compare std, red gate sql data standard, redgate sql data standard, buy sql data compare standard, sql datacompare standard, red gate datacompare standard, redgate datacompare standard
Red Gate Software Red-Gate RedGate
SQL query language
Verification Verify verified Check Checking
Database DB Management
Database DB Reporting Report reports
Part numbers: PC-516296-567623 516296-567623 PC-516296-567625 516296-567625 PC-516296-567627 516296-567627 PC-516296-567629 516296-567629 PC-516296-567631 516296-567631 PC-516296-567633 516296-567633 PC-516296-567635 516296-567635 PC-516296-567637 516296-567637 PC-516296-567639 516296-567639 PC-516296-567641 516296-567641 PC-516296-567643 516296-567643 PC-516296-567645 516296-567645 PC-516296-567647 516296-567647 PC-516296-567649 516296-567649 PC-516296-567651 516296-567651 PC-516296-567653 516296-567653 PC-516296-567655 516296-567655 PC-516296-567657 516296-567657
Mfr. Part No: P21U10M12 P21U10M24 P21U10M36 P21U1M12 P21U1M24 P21U1M36 P21U5M12 P21U5M24 P21U5M36