UltraDBC general info
UltraDBC is command line program, that compares data in Microsoft SQL Server tables located in different databases/servers. It provides many command line switches for better programm control.
I created this tool when I wasted two days trying to find freeware database data compare tool. There are great freeware tools, that compare database schemas like Open DBDiff(<http://opendbiff.codeplex.com/>) and DBComparer (<http://dbcomparer.com/>). But there isn't any that would simply compare Microsoft SQL table data.
* Multithreaded programm - uses all available CPU cores for comparsion and uses two cores for data reading.
* Supports Microsoft SQL Servers starting from version 7.0.
* Simultaneous data reading from databases.
* Save SQL script to file and/or display to console. Script later can be executed with SQLCMD, OSQL or opened in any SQL Server administrator software (like Enterprise Manager).
* Limit update commands produced: Delete, Insert, Update can separately be excluded from result script.
* Choose between Windows Integrated and SQL server autientification modes.
* Control programm entirely with command line switches, and use it in batch processing.
For complete software manual visit [Software manual].
Wishlist (Planned features)
* Multiple table comparsion
* Compare table column specifications before actual row compare;
* Support settings file in addition to command line;
* Support for MySql.
* Add transaction support option in generated script.
For detailed planned features list, please visit [Planned feature list].
* Can compare only single pair of tables per run.
* Does not check for column equality - just assumes they're equal.
Tools needed to run software
This software will run on any Windows, that has Microsoft .NET framework 2.0 or newer installed. Thereforre programm will run correctly on: Windows 98SE, Me, Windows 2000 SP6, Windows XP SP3, Vista, 7, Windows 2003 server, 2008 Server and 2008 R2 server. If somebody has tested it on other platforms - plase let me know, to add to this list.
Currently software is tested on Windows 7. Fell free to check on other Windows versions, and let us know other platforms where softwaro also works.
If anybody wants take parte in this project - you're Welcome.
This program is completely free. In case of questions - plase contact me at <firstname.lastname@example.org> or post in message board at <http://sourceforge.net>.
Visit us on Facebook: <http://www.facebook.com/UltraDBC>