uDbCompare

uDBCompare compares various items (Doc Types, Media Types, Templates, Data Types, Relationships, Dictionary Items, Member Types & Macros) in the current Umbraco database to a remote database. 

This is a initial mostly working prototype - the results given should not be completely trusted until someone with far more knowledge of how the underlying umbraco database/system works gives it a good look over to verify the queries are correct. 

The UI could use quite a bit of improvement.

All data is stored in the umbracoNode table in plain text - so don't store username/passwords there!  There is no associated doc types or properties to keep the umbraco database clean.

v0.4 release

Fixes bug for unable to display compare datagrids
Fixes sync template button
Fixes bug in finding unused doc types

Add search for all macros
Add check for hidden tabs
Add check for possible unused doc types

v0.3 release

* Add Language Comparison
* Add DeepLinks into umbraco for most of the nodes
* Add Checks for
** Local Orphaned/Out of Sync Templates
** Local XSLT Files in Use
** Doc Types In Use
** Unused Doc Types & unused Templates
** Legacy Aliases (with space in property name)
* Include which tab a property is on for Doc Type & Media Type comparisons
* Fix bug related to server connection string if comparing multiple servers at once