SQL Prompt is the one tool that I’ve had rounds with.
A great time saver and a great investment.Īnother tool that I haven’t gotten to play with. SQL Dependency Track is a very interesting tool, and is a life saver on complicated databases, because when you need to make a change to a table you can find exactly which views, sps, etc. This is a must if you prefer updating your test and dev data with what’s in production. I now no longer have to manually create scripts to copy any data, and I no longer have to move around backups. It allows me to compare the data between two databases on the same server or different servers, script the difference, and then copy and paste the script to the target. SQL Data Compare has saved me so much time since we’ve gotten it that it probably pays for the entire license for the SQL Toolbelt in a year.
Out of all of the tools, this is the one that I’d recommend the most. Now I just back up the database, do a sql compare, and run the script that’s generated. Before we got SQL Compare I was manually creating scripts to copy data down from prod/test, creating backups, then copying and restarting from the backups to push changes to test/prod. This is the tool that I primarily had my eyes on when I first started asking for the SQL Toolbelt, and I’ve loved it ever since. Here’s my quick review of the SQL Toolbelt So far I’ve been fairly impressed with every piece of software provided by Redgate.
But with the current push we’re making with trying to straighten out our processes I’ve been playing with everything to get a feel for how they work and if I want to actually use them. So I’ve had Redgate’s SQL Toolbelt for about a year now, but up until recently I hadn’t used most of the tools available to me.
0 kommentar(er)
