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 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
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
PSPad Editor CapaLib vbScript Editor with 10.000 vbScript syntax validated function lines, compatible with the Management System from www.CapaSystems.com
You only need to type 2 letters, to get dozens of function lines pasted automatically into your vbScript.
You can e.
ScriptOrganizer ScriptOrganizer is a simple yet powerful tool which enables developers to efficiently organize scripts in ScriptMaker. - Many scripts can be selected at once and then moved as a block to a different point in the list of scripts. - Contiguous or noncontig
Multimedia Fusion Multimedia Fusion is the most flexible, powerful, and full-featured authoring tool available today. Best of all, you can get superior and impressive results with no programming skills or knowledge required. Discover the secret tool used by so many multimed
dbQwikSite Professional Edition dbQwikSite is an amazing, powerful, innovative way to build data driven web sites. Create database web sites and never write a line of code. dbQwikSite is a web application development tool with powerful features to: connect to and/or create databases, gen
GNU Emacs GNU Emacs is an extensible, customizable text editor--and more. At its core is an interpreter for Emacs Lisp, a dialect of the Lisp programming language with extensions to support text editing.
Shell MegaPack.Net Shell MegaPack.Net brings total Windows Explorer-like file and folder browser UI functionality to your forms and dialogs in just a couple of seconds. The UI controls can be put right inside your own form or dialog to provide a standard user-friendly look t
Virtual Sampler SDK Low-latency, programmable, MIDI-controlled, emulated wavetable sound engine for Visual C/C++, Watcom C/C++, C++ Builder, Delphi and Visual Basic developers.Requirements:Windows 95/98/ME/NT/2000/XP 16 bit sound card
XMLFox Professional Edition RustemSoft presents XMLFox Professional Edition that is a set of XML tools: XMLFox Advance XML/XSD editor and XML conversion module with command-line interface. XMLFox Advance is XML editing and validation tool for creating valid well-formed XML documents
ECMerge Standard ECMerge compares and merges files and folders, side-by-side. It provides syntax coloring for C/C , Java, HTML, ASP, PHP and many others. Save your work at intermediate situation and restart it later. Generate Unix patches between files. A shell extension
24U SimpleTalk Plug-In This plug-in allows FileMaker Pro to communicate with user, another FileMaker Pro, and other applications via TCP/IP. You can simply trigger scripts or evaluate calculations in remote FileMaker Pro clients, or seamlessly integrate FileMaker Pro with other
Supported Operating Systems:
Windows 2000 |
Windows 2003 |
Windows 7 |
Windows 8 |
Windows Server 2008 |
Windows Vista |
Windows XP |
Comments on :
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