NE DB Comparator Files

DB Comparator 0.6.1.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 tool, but no a synchronization tool. However is planned to include this functionality in a future version.

It was originally developed in 2005 as an internal database tool. First version only supported SQL Server 2000, but last version supports 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 constratins 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.

Not supported features (yet):
-----------------------------
- Ignore field order during table comparison
- Extended properties comparison

Future planned features (ordered by priority):
----------------------------------------------
- View object details in comparison result view.
- Ignore field order during table comparison
- Extended properties comparison
- Help file
- MS SQL Server databases synchronization scripts.
- Support for Oracle database comparison
- 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 2.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.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 conding.

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