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
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 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,
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
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 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
Intel Cluster Studio XE 2013 SP1 for Windows The suite provides a comprehensive set of standards-driven C, C++, and Fortran development tools and programming models for efficiently developing, analyzing, and optimizing HPC applications on Intel Xeon processors and Intel Xeon Phi coprocessors. The int
Code VB6 With Code VB coding tools added to your Visual Basic development environment (VBE) you create better Visual Basic code. A set of 20 specialized code builders supports the creation of most used code. Includes code explorer and search to find all built-in Vi
Microsoft Silverlight 2 SDK The Microsoft Silverlight 2 Software Development Kit provides documentation, libraries and tools for developing Silverlight applications.
NoSQLt API NoSQLt API is an Application Programming Interface provided by NoSQLt real-time/historical database platform for users. With NoSQLt API, users can employ their favorite programming languages to make use of all the functions of NoSQLt real-time/historical d
VBS TextBox Creator A simple batch file creator that puts inputs of text on a VBScript. You decide the number of text boxes that come and what each of them says. Hope you enjoy this very simple yet fun creation. NOTICE: It creates a temporary file that is named tempfileVBS.vb
Microsoft Visual Studio 2008 Service Pack 1 Visual Studio 2008 SP1 includes support for SQL Server 2008, new ADO.NET features such as the Entity Framework, improvements to the WPF designers, WCF templates for Silverlight projects, debugger support for the .NET Framework public symbols and source rel
Command22 All COM objects included into the Command22 package are used for running the console application or MS DOS commands from inside your application and providing your application with methods to control the child process input and output.
Command22 COM objec
Mockup Plus A powerful and easy tool that helps you seamlessly design software prototypes. Mockup Plus is a prototype building tools designed for agile development mode. Mockup Plus can be of great help for software development companies and teams for prototype buildi
xLibUDF Interbase UDF with additional functions for working with strings, mutex, creation GUID, debugging stored procedures and triggers.What is new in this release:Works with Interbase 5.0 & 5.5 Corrects implementation of ANSILike Adds function TimeStamp
Intel VTune Amplifier XE 2015 Intel VTune Amplifier XE provides the data needed to meet a wide variety of tuning needs. Collect a rich set of performance data for hotspots, threading, OpenCL locks and waits, DirectX*, bandwidth, and more. Get the tools to mine the data and make it easy
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