Competition: Win a three month subscription to Pluralsight!

Roseanna

Hello everyone,

Enter our competition to win a three-month subscription to Pluralsight!

SQL Compare is turning 21 this month (where has the time gone?!). To celebrate, we're offering you the chance to win a three-month subscription to Pluralsight* in this month's forum competition.

To enter, please tell us 'How SQL Compare has helped you' in the thread below.

The competition closes at midnight BST on 1 December. The winner will be randomly selected from the entries received.

Good luck!

Roseanna 

*Pluralsight is a technical skills platform that provides web development, IT certification and online training that helps you move forward with the right technology and the right skills. 

ben_b

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.  

Andrew18

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

RomainCasteres

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 !

MLysons

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. 

eliassal

SQL compare helps accelerate work and avoid time lost in tedious tasks

Venkatroyal

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.

Kevin3NF

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!

NaveenKumar

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  

SS19

I quick guide for all solutions.

DBAGreg14

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.

angelos

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 .

fhanlon

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.

mgc

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

npensa

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.

Roseanna

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.