xSQL Data Compare for SQL Server is a tool for comparing and synchronizing the data in two SQL Server databases. You can use it for data migration, auditing, replication verification, populating development databases with production data. Some of the features include: 1) Full support for SQL Server 2014, SQL Server 2012, SQL Server 2008R2, SQL Server 2008 , SQL Server 2005, and SQL Server 2000; 2) Cross version comparison - compare databases on different SQL Server versions; 3) One-click re-compare - complete comparison configuration stored in session allows for a one click re-compare; 4) Custom mapping rules feature allows the user to customize the way database objects are paired together. Mapping rules include: "Schema mapping rules" that determine how the schemas are mapped; "Name mapping rules" that determine how the object names are mapped; and "Data mapping rules" that determine how data types are mapped; 5) Custom comparison keys - need to compare tables or views but they are showing as non-comparable because there is no primary key or unique indexes defined on them? Once xSQL Data Compare for SQL Server has analyzed the schema it will allow you to define a unique key (any combination of the fields of that table) to use for the comparison. The rows are paired based on the selected key. 6) Command Line utility - the included, highly configurable command line utility allows you to schedule comparison and synchronization operations via the Windows Task Scheduler, SQL Server Scheduler. 7) Handling large databases - custom built algorithms handle serialization of both data rows and script fragments as needed ensuring strict control of the memory utilization. 8) Script execution engine - the proprietary, intelligent script execution engine ensures that very large t-sql scripts including scripts for binary columns and large text columns are executed successfully while providing continuous progress information and allowing you to safely interrupt the script if necessary.
What is new in this release:
- Support for SQL Server 2014 (also supports SQL Server 2012, SQL Server 2008/2008R2, 2005, 2000)
- New comparison engine - robust, highly efficient comparison engine compares millions of rows faster while tightly controlling resource utilization.
- New modern GUI: the graphical user interface has been completely reworked to reflect the latest standards in user interface design.
- Workspace: an improved, simplified workspace that provides for a one click re-compare eliminating the hassle of repeatedly configuring comparison sessions.
- Improved memory management: eliminates any database size limitations due to memory constraints. Custom built algorithms handle serialization of both data rows and script fragments as needed.
- Error handling: non-critical errors are registered and reported but do not stop the data comparison operations.
- Enhanced functionality: many new options have been added like the ability to compare views, ability to compare databases with different collations, variable transaction size etc.
- Mapping Rules: allow the user to customize the way the database objects are paired together. Mapping rules include schema mapping, object name mapping and data type mapping.
- Key validation: in addition of the data type compatibility the new SQL Server Data Compare provides for validating the uniqueness of the selected comparison key.
- Improved Scripting: especially for binary fields and large text fields. The script for large fields is generated in fragments of a predefined size and sent to SQL Server one block at a time.
Requirements:
.NET Framework 4.0
Comments not found