Add the "solution" concept for multiple projects
It would be nice to allow comparison "solutions" where you could have multiple projects bundled together. The solution comparison could be run in a single step, and all projects would be run with results in separate tabbed windows. For example, on a weekly basis I need to compare DEV and LIVE schemas for nine databases. I have nine separate projects that I need to open and run. If I could bundle these into a solution, run the solution and have all nine projects run and get their results displayed in tabs, that would save a ton of time.
-
Dwaine Wright commented
It is really surprising that this only had one vote. The basic concept is this, redgate has been doing this a long time, and their tools rock, but they've also been mired in a database-centric mentality. That was fine when SQL compare (and even SQL Source Control) was new, but there needs to be a more "instance-centric" or even "enterprise-centric" shift in paradigm. How many enterprise applications use only one database, or even only one instance? The solution suggested by the OP has been sorely needed for years. Years ago, I used the SDK to roll my own console app to implement an enterprise "version monitor" by simply enumerating servers and their databases, dumping snapshot files named by Instance-DB-Timestamp or comparing the DB to the most recent file, generating a new file if any changes were detected. A GUI based app that would provide a similar configured 5000 foot view would be outstanding. DLM dashboard (haven't had time to evaluate it yet) is a server / DB based solution that is overkill for what's being asked. The concept of simply extending SSC and/or SQL Compare projects to support a file based solution approach should be strongly considered.
-
Are you referring to comparisons using SQL Compare rather than SQL Source Control? I'd be curious to know if you've tried using the DLM Dashboard and whether this helps solve the problem you have? http://www.red-gate.com/products/dlm/dlm-dashboard/