Name | Modified | Size | Downloads / Week |
---|---|---|---|
Parent folder | |||
README.txt | 2011-01-03 | 3.5 kB | |
DBComparator-win32-setup.exe | 2010-12-31 | 4.8 MB | |
NEDBComparator-source.rar | 2010-12-31 | 39.1 kB | |
Totals: 3 Items | 4.8 MB | 0 |
DB Comparator 0.5.1.0 Release Notes Contents --------- - Description - Main features - Not supported features - Future features - Installation - Source code Description: ------------ NE DB Comparator is an application that allows comparing of two MS SQL Server databases. This program gets differences and shows them in a 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 at Neotech Engineering. 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 check constraints. - Allows select options to be used during table comparison: Include fields, compare string collations for char or varchar fields, include primary key, include foreign keys, and include indexes. - 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 - Index comparison - Check Constraints comparison - Trigger comparison - Option to ignore objects existing only in source database - Option to ignore objects existing only in target database - Option to ignore objects existing in both databases - Extended properties comparison - Full support of schemas for stored procedures, views Future planned features (ordered by priority): ---------------------------------------------- - Full support of schemas for stored procedures, views - Ignore field order during table comparison - Index comparison - Check Constraints comparison - Trigger comparison - Option to ignore objects existing only in source database - Option to ignore objects existing only in target database - Option to ignore objects existing in both databases - 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). To install download and run setup executable and follow on screen functions. For any issue with installation, please write in the help forum. Source code: ------------ Program is written in C++ by using C++ Builder 6, however it has been tested with Turbo C++ 2006, which is freely downloadable. Currently source code is dependent of a Neotech library, which is proprietary code. However its dependency is just for few helper functions. They can be made open source if requested. New version has been totally rewritten in C# and is not dependent of any proprietary code. It will be published by January 10th /2010.