Competition: What’s your favorite Redgate tool?

Comments

• jermyh_controlup Posts: 1 Bronze 1

  July 15, 2021 6:50AM

  SQL Prompt by far!!!
  It saves time more then any other tool in DBA/DB Developer day-to-day tasks!
  It makes order and adds a real valuable info enrichment

  2 · Share on Twitter
• jboyer Posts: 12 Bronze 2

  July 16, 2021 9:50PM

  SQLPrompt... cannot code without it!

  3 · Share on Twitter
• Jeff Moden Posts: 8 Bronze 1

  July 17, 2021 5:40PM

  I don't use SQL Prompt.  I used to work on a whole lot of different systems for many different companies and a lot of them did use it so I never picked up the habit so I wouldn't get used to using it and possibly being lost without it.  Who knows?  It could become a favorite tool.

  
  

  For now, though, and for  the last 10 years, SQL Compare has been my favorite RedGate tool.  The methodology we currently use for final checks after UAT is to do a restore of the production database(s) affected and do the full database deployment on that.  Then, we do a compare between that and the production database.  We also have a rigid standard for how the flower box of code must be laid out especially when it comes to revisions.  Yeah... I know that may sound stupid for this day and age but comparing the flower box with those revision tracking comments have saved our hinnies more than once because people can't seem to handle trunks right for SQL especially for long term projects that aren't even close to being CICD.

  
  

  It's a whole lot easier than pawing through trunks and branches and all sorts of other stuff to make sure that there is no regressive code and, at the same time, ensure that everything actually has been both peer reviewed and reviewed by a DBA.
  

  -1 · Share on Twitter
• hannu Posts: 1 Bronze 1

  July 20, 2021 5:30AM

  SQLPrompt -- i just can't work without it , saves me tons of time 

  3 · Share on Twitter
• gbe Posts: 1 Bronze 1

  July 27, 2021 4:32PM

  SQL Prompt too!
  

  1 · Share on Twitter
• deboraht007 Posts: 3 Bronze 1

  July 27, 2021 7:04PM

  SQL Compare has saved me so much time and effort in numerous situations, but day to day it's SQL Prompt, hands down.

  1 · Share on Twitter
• Sc0tt Posts: 1 New member

  July 28, 2021 3:08PM

  SQL Compare by far, saved hundreds of hours of testing while migrating servers! 

  1 · Share on Twitter
• deepsompura Posts: 1 New member

  July 29, 2021 12:40PM

  Sql Prompt is my favorite tool.. 

  1 · Share on Twitter
• gnbfilho Posts: 5 New member

  July 29, 2021 2:51PM

  SQL Prompt! I get desperate when I have to code without it!

  1 · Share on Twitter
• iSoft Posts: 1 New member

  July 30, 2021 12:28AM

  Sql Prompt , every developer need it !
  

  1 · Share on Twitter
• Jimbog Posts: 0 New member

  July 30, 2021 6:50AM

  SQL Dependency Tracker is a long time favorite. Is it still free?

  1 · Share on Twitter
• rob_wingate Posts: 7 Bronze 1

  July 31, 2021 11:17AM

  I have been using SQL Compare, SQL Data Compare, and SQL Multi Script since around 2007 and it would be hard to live without any of them! I would cry if I had to
  

  1 · Share on Twitter
• Marc_M Posts: 1 Bronze 1

  August 1, 2021 9:55PM

  SQL Monitor, helped me find & resolve issues on production databases that had existed for a long time.
  

  1 · Share on Twitter
• karnatibharathkumar Posts: 2 New member

  August 2, 2021 5:01AM

  I liked sql data compare a lot. With this lot of ours manual efforts saved and our data is in sync. We developed various automations using powershell and sql data compare to do automatic data compares. we are in process of leveraging sql compare tool as well. 

  1 · Share on Twitter
• Kev Posts: 6 New member

  August 2, 2021 6:52AM

  We have SQL Toolbelt 
  SQLPrompt  - All day everyday it saves so much time
  SQLCompare - great tool to assist in generating change scripts from Dev to Prod
  SQLSourceControl - greet tool helping is with change management in our BI env
  SQL Data Generator - Just started using this tool. it has limited use for us but very helpful when i need to fill a table with some random test data 

  1 · Share on Twitter
• JBSS Posts: 1 New member

  August 4, 2021 6:47AM

  SQL Compare, hands down. 
  Just saves so much time deploying changes in development DB's to Live dbs.

  1 · Share on Twitter
• SOlson Posts: 5 Bronze 1

  August 4, 2021 11:11PM

  most used: SQL Search, followed by SQL Source Control
  

  1 · Share on Twitter
• lupji Posts: 1 New member

  August 5, 2021 11:38AM

  SQL Monitor by far the most useful tool. This is my best friend as I am a DBA. 
  Can't thank you guys enough.

  1 · Share on Twitter
• Udit1995 Posts: 1 New member

  August 6, 2021 4:03AM

  SQL Change Automation and SQL Clone are two of my favorite redgate tools.
  With SQL Change Automation we successfully managed versioning of database having 15000+ objects. The speed with which this software reads the schema is exceptional, Also it creates migration scripts where sequence is automatically generated.
  SQL Clone helped us to create replica of database for various environment and best thing about SQL Clone is that size of the clone generated is comparatively very less than the original copy.
  
  

  1 · Share on Twitter
• LouisSomers Posts: 24 Bronze 2

  August 6, 2021 8:28AM

  SQL Source Control is my favorite by far, Having the whole schema neat and tidy split up into separate folders and files, and being able to trace changes back to bugs or features, and see who implemented those changes, when and why... That's so valuable!
  
  Without this ability we would absolutely require to build regression test automation in order to solve bugs flipflopping each other over time (fix of bug A causes bug B and vice versa where the bugs would swap existence in following releases). Regression tests are great, but using the Annotate / Blame feature of a source control tool can provide a faster route and save a ton of time and confusion.

  1 · Share on Twitter
• Guenter Posts: 12 Bronze 1

  August 9, 2021 9:43AM

  SQL Prompt for hourly needs, SQL Source Control for daily needs.
  Without the one I couldn't read code produced by others (long ago) and produce code readably by others (now).
  Without the other I'd be lost in a dev database used by all developers simultaneously.

  1 · Share on Twitter
• mastersson Posts: 1 New member

  August 9, 2021 2:04PM

  We have close to 100 different databases, many of which have some specific deployment requirements to ignore particular objects, Redgate's tooling particularly the combination of Sql Source Control with the DLM automation tools, allows for flexibility and filtering of files as well as comparison options!
  

  1 · Share on Twitter
• DevendraSingh Posts: 16 Bronze 1

  August 10, 2021 5:13AM

  sql prompt

  1 · Share on Twitter
• MaterekeT Posts: 1 New member

  August 10, 2021 8:50AM

  SQLPrompt -saves me lots of coding time 
  

  1 · Share on Twitter
• ProMi Posts: 1 Bronze 1

  August 10, 2021 3:06PM

  SQL Prompt
  

  1 · Share on Twitter
• SocialExodus Posts: 4 Bronze 2

  August 10, 2021 4:32PM

  SQL Prompt, hands down.  I'd buy my own license if my company gets stingy on providing it lol

  1 · Share on Twitter
• JonathanC Posts: 15 Bronze 2

  August 10, 2021 5:41PM

  SQL Prompt, followed closely by SQL Compare. Both are critical to my job functions.

  1 · Share on Twitter
• Steve_77777 Posts: 3 Bronze 1

  August 10, 2021 7:53PM

  SQL Prompt!  I never get tired of singing its praises.  Feel like such a newbie if I'm VM'd to a server without it.
  
  SQL Search gets an honorable mention.
  
  You'd think MS would cook the functionality of these into SSMS so a big THANK YOU to Redgate for filling that gap.

  2 · Share on Twitter
• mmcdonald Posts: 1 New member

  August 10, 2021 11:15PM edited August 10, 2021 11:16PM

  SQLPrompt.  The auto complete -- check.  Dump directly to Excel ("new" format) -- check.  Procedure parameters -- Check.  Formatting -- check.  Drag/drop -- check.  Save tabs -- check.
  

  
  

  HUGE time saver -- CHECK

  
  

  SQL Search is a great frequently used freebie
  

  1 · Share on Twitter
• manjuke Posts: 4 Bronze 2

  August 11, 2021 12:34AM

  SQL Prompt

  ---

  Manjuke
  http://www.manjuke.com

  1 · Share on Twitter