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.
Other Windows Software of Developer «XSQL Software - Bright Minds Group»:
xSQL Script Executor Script Executor is a professional grade database tool that allows you to deploy multiple Sql scripts on one or more target servers with a click of a button. Script Executor supports SQL Server 2008/2005/2000, MySQL 5.0/5.1, DB2 9.0 and SQL Server Compcat E
xSQL Documenter xSQL Documenter is a comprehensive, uniform, and easily navigable database documentation for all your applications. It generates documentation in HTML and compiled CHM format; supports all major database management systems: SQL Server, Oracle, DB2, MySQL,
RSS Reporter for SQL Server RSS Reporter for SQL Server is a simple, yet extremely useful, tool that generates standard RSS feeds containing information regarding SQL Server jobs like the current status of the job, job details, historical status; feeds containing information generate
xSQL Profiler xSQL Profiler is an easy to install, easy to use, agent-less SQL server monitoring tool that can be utilized for performance, auditing and compliance related tasks. It monitors multiple SQL Servers from one central location and chooses SQL Servers and data
Oracle Data Compare xSQL Data Compare for Oracle is a database tool for comparing and synchronizing the content of Oracle databases. Its intuitive multi-session capable GUI and the command line utility can be used by database administrators or Oracle developers to synchronize
xSQL Object Search xSQL Object Search support all types of database objects from tables and views to CLR objects and Xml Schema Collections, you can search all database object types. Search the name or the definition chooses to search on the name of the objects, the T-SQL st
xSQL Builder xSQL Builder is a SQL tool that allows for automating the deployment of SQL Server based solutions. It generates executable packages that contain all the information and logic required to deploy the database to the clients environments regardless of whethe
Run Service ActiveX Run Service ActiveX is a powerful tool for quick creation of Windows Service. All that you have to do is to register the ActiveX Control in your system and place it on the form. Now you may use all the benefits of Windows Services. Using this control's met
EasySQL Checker for Oracle EasySQL Checker for Oracle is a SQL syntax validation tool, It can check to see whether a SQL statement syntax is valid before you actually run it against Oracle. It can opens several SQL files together and check all on the fly, then you can go directly
formlayout (64-bit) Formlayout (64-bit) is a tiny Python module for creating form dialogs or widgets to edit various types of parameters with having to write any GUI code. The main advantage of formlayout (64-bit) over similar libraries is that it's very simple to use/install
ReportMax CppMAX is pleased to announce the Release of ReportMAX - the specially crafted free reporting tool for .net developers. Speed, compactness, minimal dependencies, and yet feature-rich tool that integrates seamlessly with Visual Studio.net 2010, 2012 and 201
WinFormWizard for .NET 2.0 WinFormWizard for .NET 2.0 is a flexible and feature rich wizard framework. Its primary design goal is to provide re-use through inheritance. This design philosophy allows wizard pages created for one wizard dialog to be re-used in another. WinFormWizard
Digital School Digital School is complete Student Management integrated software application that spans across all functional requirements of educational institutes like student admission system, examinations, fees, attendance, library, hostel, stores and staff payroll.
.NET Obfuscator Professional .NET Obfuscator Professional is .NET code protection tool to secure .NET assemblies. Obfuscation significantly aggravates reverse engineering and reduces its effectiveness.
Skater .NET Obfuscator is a comprehensive professional solution for .NET applicati
Visual Paradigm for UML Visual Paradigm for the Unified Modeling Language (VP-UML) is a UML tool. The tool is designed for a wide range of users including software engineers, system analysts, business analysts and system architects, or for anyone who is interested in reliably bui
Authorware Updater Create everything from web-based tutorials to sophisticated simulations incorporating audio and video with Macromedia Authorware, the leading rich-media authoring solution for e-learning. Deliver your applications on the web, corporate networks or CD-ROM,
WebsitePainter WebsitePainter is a web editor for creating professional looking Websites, without HTML knowledge and programming. It includes a variety of templates and supports important Web standards such as HTML, CSS, PHP, and ASP. WebsitePainter allows you to place a
Supported Operating Systems:
Windows 2000 |
Windows 2003 |
Windows 7 |
Windows 8 |
Windows Server 2008 |
Windows Vista |
Windows XP |
Comments on xSQL Data Compare for SQL Server:
Comments not found
Windows Software - Free Windows Downloads, Apps, Games, Freeware, Skype, Media Player, Antivirus, Gimp, Live, Starter for Windows XP, Vista, 7, 8, 10