StrataFrame Forum » .NET Forums » General .NET Discussion » SQL Tools

SQL Tools

Larry Caylor — Thu, 11 Jan 2007 12:15:12 GMT

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?

RE: SQL Tools

StrataFrame Team — Thu, 11 Jan 2007 12:15:12 GMT

Yes, the DB functionality that they added is quite extensive.

RE: SQL Tools

Larry Caylor — Thu, 11 Jan 2007 12:02:43 GMT

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

RE: SQL Tools

StrataFrame Team — Thu, 11 Jan 2007 11:47:44 GMT

If you're doing a straight copy of one development database to another, then Red-Gate's SqlBackup might be your best bet. We use their ANTS profiler and have had great luck with it, but I haven't tried the SqlBackup.

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.