August 15th, 2011, 06:25 AM
Excellent Analysis of Table Data Differences with dbForge Data Compare for SQL Server
Devart provides the state-of-the-art capabilities for table data comparison, analysis, and synchronization in new release of SQL compare tool for SQL Server.
Devart has presented the release of dbForge Data Compare v3.0 – a distinguished data comparison and synchronization tool.
Among numerous improvements, featured in the new version of the product are data comparison report redesign and ability to compare results of custom queries. Other major improvements include support of SQL Azure databases.
All the new features and possibilities available in dbForge Data Compare for SQL Server v3.0 are as follows:
* New extended data comparison reports
- Offline analyzing of comparison results made possible by exporting real data into the report;
- New Comparison Report wizard;
- Comparison report can include only columns containing differences for the rows that contain differences;
- The number of changes for each column can be included into the comparison report.
* Custom query result comparison
Version 3.0 of dbForge Data Compare for SQL Server contains the custom query result comparison feature, which can be used to compare results of specific queries. This proves exceptionally useful in case you need a customized comparison instead of comparing all data in your database.
* SQL Azure Support
Comparing data and synchronizing SQL Azure databases has just become as easy as processing common ones. dbForge Data Compare for SQL Server fully supports SQL Azure database connection and processing.
* More flexible comparison settings
- Possibility to use "One-to-many" objects mapping when some columns in the target database were separated as a table;
- Possibility to include objects into comparison by mask. It is useful when you need to compare groups of tables;
- Possibility to choose a random index as a comparison key was added;
- Options for ignoring difference in time for DATETIME fields added.
* Improved analysis of comparison results
- Possibility of quick navigation through data differences;
- Full-text data search;
- Possibility to hide unchanged columns in the result data grid;
- The number of differences per column is now displayed on the status bar;
- Possibility to view a random set of columns in data grid;
* SQL Server Management Studio Integration
From now on you can quickly launch your comparison right from the Object Explorer context menu as well as from the SSMS main menu.
* Other improvements
- Extended examples on command line usage added;
- Additional user interface skins support;
- Redesigned start page.
* Pricing and Availability
Consumers can try the updated dbForge Data Compare for SQL Server by downloading the 30-day evaluation version at the product download page.
dbForge Data Compare for SQL Server license price starts at $149.95.
To leave feedback, users are welcome to the dbForge SQL Complete feedback page:
* About Devart
Devart is a widely recognized provider of database connectivity solutions and tools for the most popular databases, including MS SQL Server, MySQL, Oracle, PostgreSQL, InterBase, Firebird and SQLite.
Since 1998, Devart has been focused on the development of native database data access solutions, development and database tools for a wide range of databases and development technologies. Now, Devart solutions provide the fastest data access available on the market and the broadest database support to many thousands of industry professionals.
For additional information about Devart, visit www.devart.com/company/
Tags for this Thread
Click Here to Expand Forum to Full Width
This is a CodeGuru survey question.