NE DB Comparator Files

DB Comparator 0.6.5.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. A preview of syncronization GUI is included in this version.

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 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.
- Sync view display a list of matching database objects and allows filter objects by type or by differences. Also allow check objects to sync
- Script generation is under development.
- English and Spanis GUIs are supported based on control panel regional settings. 

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

Future planned features:
----------------------------------------------
- MS SQL Server databases synchronization scripts.
- 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.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 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