NE DB Comparator Files

DB Comparator 0.7.0.0 Release Notes

Contents
---------
- Description
- Main features
- Not supported features
- Future features
- Installation
- Source code
- Fixed bugs and new features

Description:
------------
NE DB Comparator is an application that allows comparing of two MS SQL Server databases. This program gets differences and shows them in side by side tree views. 

This software is a comparison and synchronization tool, but synchronization is under development and is currently included partially.

Supports both SQL Server 2005 and 2008. 

Main features:
--------------
- Allows creating, saving and loading Project files. A project includes a set of database connection parameters and the comparison selected options that can be retrieved for future use. 
- Filter the kind of objects to be compared: tables, procedures, functions, views, user data types and rules.
- Allows select options to be used during table comparison: Include fields, compare string collations for string fields, include primary key, include foreign keys, include indexes, include constraints and include triggers.
- Allows other options during compare: Show identical objects in result (very time consuming in large databases), control case sensitive comparison.
- Allows Selection of two databases to compare, between all database connections stored in a project.
- Shows Comparison progress.
- Show results in side by side tree views, with synchronized scroll. Differences are highlighted with orange color.
- Sync view display a list of matching database objects and allows filter objects by type or by differences. Also allow check objects to sync.
- Partial synchronization is supported with no dependencies analysis:
	-create and drop tables (includes identity, primary key, indexes, default constraints and foreign keys).
	-create drop and update procedures
	-create drop and update functions
	-create drop and update views
- English and Spanish GUIs are supported based on control panel regional settings. 

Not supported features (yet):
-----------------------------
- Ignore field order during table comparison
- Extended properties comparison
- Ignoring all system tables option (sysdiagrams).
- Scripting for update table structure (only create and drop tables)
- Scripting and user defined data types
- Scripting of complex data tpyes
- Dependencies analysis during script generation

Future planned features:
----------------------------------------------
- Complete MS SQL Server databases synchronization scripts of comparison supported objects.
- View object details in comparison result view.
- Ignore field order during table comparison
- Extended properties comparison
- Help file
- New feature requests are welcome

Installation:
-------------
Supported OS: Windows 2000/XP/Vista/7/2003/2008
Prerequisites:
- MS SQL Server Client Connectivity components (Included in MS SQL Server installer).
- MS .NET Framework 4.0
Before install, remove any older version. 
To install DB Comparator download and run setup executable and follow on screen instructions.

For any issue with installation, please write in the help forum.

Source code:
------------
Program is written in C#, and is not dependent of proprietary code. All required code is included.

Fixed bugs and new features
-------------------------------
Version 0.7.0.0
- Scripting to create tables, including identity, indexes, default constraints, and delayed foreign keys.

Version 0.6.5.3
- Cells in sync view were editable. Fixed.
- Scripting to drop tables

Version 0.6.5.2
- Generation of synchronization scripts included (procedures, functions, views), with no dependencies analysis.
- Minor user interface improvements.
- Exception in sync view construction during comparison, when user defined data types differences were found, fixed.
- Misplaced images in results view fixed.

Version 0.6.5.1
- Error in folder names in result view fixed.

Version 0.6.5
- Includes a preview of sync functionality

Version 0.6.1.0
- Include table check constraints comparison
- Include table trigger comparison
- Few GUI improvements:
	- Select DBs to compare is the first view at program startup.
	- New connections can be made from Select DBs view 


Version 0.6.0.0
- Full support of schemas for stored procedures, views and functions
- Index comparison is now ready.
- There are several small GUI improvements.
- Project files have been totally redesigned, and now they are stored in XML files (wit .DBC extension)
- This version has been fully rewritten in C#, but keeps the same look and feel of previous version.
- Source code use the same logic, but is a lot more readable than previous version written in C++. 
- Source code has a few optimizations.
- Comparison code has been separated from GUI, for a more organized coding.

Version 0.5.1.1
- Basic views comparison fixed.
- Basic functions comparison fixed. 
- Connection with integrated security fixed to avoid login window.
- Installer fixed