August 11, 2015 at 11:44 am
Hi, what are the most common source control tools for SS in a multi-developer environment? Several years ago it seems like Redgate was the preferred tool or at least the market leader. Is this still the case or does it have any real competitors?
August 12, 2015 at 5:32 am
Full disclosure, I work for Redgate.
There are really two tools on the market that provide everything you need for database build and deployment. The first is Redgate SQL Source Control and some of our related tools. We have a web site dedicated to education around database deployment and database lifecycle management[/url].
The second tool, and it's a good piece of software, is SQL Server Database Tools from Microsoft. It works within Visual Studio to provide you with a means of getting databases into source control and then building and deploying from there in an automated fashion.
I've built fully automated database deployment processes using both tools. Honestly, the amount of work for either tool is about the same. The main differences are in where the work occurs. Redgate works primarily within SQL Server Management Studio (although that's changing). SSDT works exclusively within Visual Studio. There are other smaller differences and a few differentiators, but I don't want to get into a sales pitch. Either tool will get the job done.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 12, 2015 at 9:29 am
I agree with Grant. Both of those tools are good and I've used both at some level. You can also sort of use both tools together as each has its own strengths and weaknesses and combined they can fill in each other's gaps. For instance, SSDT forces you to use Visual Studio and there is no tie directly to a database. SQL Source Control works in SSMS and ties to a physical database, but doesn't handle database properties like Full Text Enabled, etc... I haven't played with the latest version of SQL Source Control, but I know at one point redgate was working on integrating SQL Source Control better with SSDT database projects.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply