The DDT works well in a lot of situations but I’m finding there are times when I need a more powerful set of SQL tools. Looking at MSDN magazine and the net it appears that Red-Gate and Apex SQL are the leaders in this area (At least they seem to spend the most on advertising). Anyone have any experience with either or both of these products and have a recommendation as to which is the better product?

You might also consider purchasing a copy of the new Visual Studio 2005 Team Edition for Database Developers... I have looked at it, and it does just about everything for you... scripting of entire databases, migrating of objects, and even unit tests for your T-SQL Stored procedures.  I'm sure you can find a 180 day eval copy of it off of the MSDN website somewhere, and if you have an MSDN subscription, it might already be available to you.

Ben,

Thanks for the suggestion. I’ve tried the ANTS profiler and have decided to order a copy. I just heard of the Database Developer version of VS a few days ago when I was surfing the MS web site; I’ll take a look at it. I’m currently running the Architect version of VS and it doesn’t have all the DB related stuff I’m looking for.

-Larry