Comparison Review: Microsoft SSDT vs Redgate SQL Source Control

Comparison Review: Microsoft SSDT vs Redgate SQL Source Control

Summary

To re-cap, here are our winners for each category:

• Ease of use: Redgate
• Refactoring: SSDT
• Filters: Redgate
• Static data: Redgate
• Money: SSDT

So which is better? Which would I recommend? Well, like most things, it depends. If there was a simple answer you probably wouldn’t be asking the question.

If you have read all the above and anything has jumped out at you as being particularly important to you and your team, great. Otherwise, if you are still undecided, the proof of the pudding will be in the eating. SSDT comes free with Visual Studio and Redgate offer a free trial – so download both and give them a try.

When I went to visit Farm Credit Mid-America, we set up three parallel proof of concepts (PoCs) and our cross-functional team voted (unanimously) for their favourite. As a result, implementation was much easier for them:

 

Whichever you choose, both products are an excellent investment of your time and/or money.

 

Why You Should Use a SSDT Database Project For Your Data Warehouse

 

作者:Chuck Lu    GitHub