I am learning about dealing with migrating database changes within a test environment and need some good tools to help me. Earlier I had looked at SQL Delta and was somewhat impressed. It got some data synchronized pretty easy and the price is good.
However, I may have been missing something but dependencies weren't detected very well in the table structure so I looked around some more. I found a tool by Apex called SQLDiff which is a bit more money but the interface is far easier to work with and manages the dependencies in the db for me. Overall, I simply didn't have to think alot and if I wasn't intimately acquainted with the table structure I'd still be able to perform actions on my db with this tool.
The UI is very easy to navigate around and I found things like editing and creating projects to be a breeze. I am new to these things so that is a big plus in my book. Since this provides both data comparison and schema comparison, i think the prices is right.
Check em out at http://www.apexsql.com/.
MIKE