Competition: Win a three month subscription to Pluralsight!

• 
  It has bailed out a lot of teams I have worked in whose database development process could only be described as a free-for-all.  

  ben_b October 26, 2020 08:53

  - 0 +
• 
  SQL Compare allows us to compare hundreds of PROD db schemas against master schemas(QA) and react accordingly if schema(s) mismatch occur.

  Andrew18 November 15, 2020 01:01

  - 0 +
• 
  SQL Compare helped me to compare quickly different SQL Server schemas (Dev, Test, Prod) and create deployment scripts as well as helping me to fix errors. Thanks !
  

  RomainCasteres November 19, 2020 08:25

  - 0 +
• 
  SQL Compare was the final piece in our switch from a manual source control system - .sql files, with _<Version Number> suffix) - to a much more automated source control system. It has been beneficial when deploying changes because it lets you see the intended changes before you deploy, and hence it can avert problems that we may have missed before.

  MLysons November 19, 2020 09:20

  - 0 +
• 
  SQL compare helps accelerate work and avoid time lost in tedious tasks

  eliassal November 19, 2020 10:57

  - 0 +
• 
  With SQL Compare, I was able to identify lot of DB related issues quickly which not only saved time, provided opportunities to make decisions quickly. Thanks.

  Venkatroyal November 19, 2020 11:54

  - 0 +
• 
  SQL Compare (and Data compare) helped me become a speaker on the SQL Saturday circuit when I presented/demoed both tools at the North Texas SQL Server User Group in 2004. I overcame my fear of public speaking that day and started do other, smaller things until I was ready for prime time.
  
  Oh...and I've rescued more than a few downed servers with the tool as well
  
  I already have a full author subscription to Pluralsight, so no contest entry here...just telling stories!

  Kevin3NF November 19, 2020 12:53

  - 0 +
• 
  SQL Compare tool helped us to compare our code from different environment with quick timeframe and deploy it with ease. I always recommend people to use this tool to know what magic it can do

  NaveenKumar November 19, 2020 13:27

  - 0 +
• 
  I quick guide for all solutions.

  SS19 November 19, 2020 16:33

  - 0 +
• 
  it recently helped me identify that only 1 table had a missing column that i can add instead of trying to restore an entire database, and take an outage.

  DBAGreg14 November 19, 2020 16:44

  - 0 +
• 
  With Devs throwing random scripts at us saying 'ok this is all we need to move to production' SQL compare is a life saver. I always use it to move new databases to production: 
  - create an empty database in production
  - compare the dev database with the empty production 
  - deploy the 'differences' 
  
  Not completely bulletproof but saves you a big chunk of pitfalls .

  angelos November 23, 2020 06:38

  - 0 +
• 
  We use SQL compare to promote changes to objects from Dev, to stage, to Prod.  This helps ensure consistency in the various environments.  We have on more than one occasion found objects that someone "forgot" in stage and never promoted up.  It is a valuable tool in our change process.

  fhanlon November 24, 2020 15:26

  - 0 +
• 
  SQL Compare allows me to quickly check schemas of DBs in different environments and address any discrepancies.

  mgc November 26, 2020 13:00

  - 0 +
• 
  SQL Data Compare allowed us to trim down the backup time of one of our databases by only copying the different rows between them instead of migrating the whole database.

  npensa November 30, 2020 21:19

  - 0 +
• 
  Thank you to everyone who shared their stories about how SQL Compare has helped you. We've really enjoyed reading them and are thrilled that this tool has helped so many of you.
  
  I'm delighted to announce that winner of a 3 month subscription to Pluralsight is @fhanlon  Congratulations! I'll be in touch with further details about your prize shortly.
  
  While this competition is now closed, you may be interested in our new Redgate Tool Tips Swap. We've launched this tip sharing activity to help everyone get more out of their Redgate tools and learn and share with the community. Find out more.

  Roseanna December 02, 2020 09:29

  - 0 +

Add comment

Please sign in to leave a comment.