Sql toolbelt redgate software#

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

Sql toolbelt redgate software#

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.