August 22, 2014 at 8:43 am
My company uses TFS and therefore all of the database development goes through Visual Studio. We just seem to have general issues with trying to manage the various pieces people are working on and general best practice questions. I'm trying to find a great source of information on how to best utilize Visual Studio and TFS for Database development. Any and all suggestions are greatly appreciated, thanks!
-Arthur
August 22, 2014 at 8:59 am
It's a little outdated, but I wrote the source control chapters on this book on Team Development. It covers some of what you're looking for. Also, my company, Red Gate Software, has a lot of educational material on team development here. Either of those resources should help.
"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 25, 2014 at 6:40 am
You sir need no introduction, thank you for your reply. With my previous company I had them go with Red Gate's Source Control with Mercurial which was so much easier being database-centric, which is why I'm getting frustrated with Visual Studio and GDR. I realize you might have a slight bias towards Red Gate, but in your opinion can Visual Studio be as seamless as SSMS and Red Gate Source Control? Thank you much!
August 25, 2014 at 7:10 am
I freely admit to my bias, but yeah, I think you can get Visual Studio to work very well. You have to plan to put the pre/post deployment scripts to work to handle things like breaking changes and security. If you've got everything in source control, you can modify the pre/post deployment scripts to get them to run scripts for you based on a labeled version or branch in source control. It's more work than what you get with Migrations in SQL Source Control, but there's every reason to expect a successful deployment process.
"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
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply