October 30, 2009 at 5:30 am
I need to know how to Control Source Code of SQL Server 2005 with Team Foundation Server.
VS 2008 DB Edition does it all but it is VERY expensive. I am looking for third party tools that are integrateable with TFS.
Please suggest if any tool available.
Also, Is there any other way to get SQL Server Source Code Controlled.
Reason for Not using or VS 2008 DB Edition:
I have tested VS 2008 DB Edition and it allows you to Check-In and Check-Out the script file as VS C# or VB.NE Developers do. It provides complete integrated SSMS in Visual Studio IDE. But the cost of one License of VS 2008 DB Edition is almost equal to the cost of 55 copies of VS 2008 professional that we have for developers.
Thanks in Advance...
October 30, 2009 at 6:31 am
You can connect directly to TFS from SQL Server Management Studio. It will allow you to create a solution and add scripts to it, check them in & out, etc. It won't do all the wonderful build and deployments of VSTS:DB, but you get what you pay for.
Another option, if you want to do builds and deployments as well as integrate with source control, is to look into Red Gate SQL Compare. It works with TFS and will check scripts in & out. It's a lot less expensive than VSTS:DB. It's also quite a lot less functional. Again, you get what you pay for.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
November 1, 2009 at 10:19 pm
Thanks for the reply.
You can connect directly to TFS from SQL Server Management Studio. It will allow you to create a solution and add scripts to it, check them in & out, etc. It won't do all the wonderful build and deployments of VSTS:DB, but you get what you pay for.
Thats true but it requires alot of manual work. (To generate script of the database and add it in Queries. I cant add folders, etc which makes the task a bit difficult. In VSTS:DB, The script is generated in Schema / Object based by the system. Ofcourse, VSTS:DB do alot, but still, my company is not ready to spent $ 15000 and so for three DBAs :-D.
Another option, if you want to do builds and deployments as well as integrate with source control, is to look into Red Gate SQL Compare. It works with TFS and will check scripts in & out. It's a lot less expensive than VSTS:DB. It's also quite a lot less functional. Again, you get what you pay for.
Yes. I have checked this software and another 'TOAD for SQL Server'. Both supports TFS and very handy.
Thanks once again.
November 3, 2009 at 2:22 pm
Try to use TOAD for SQL Server that has this functionality built in.
Good luck!
Jacob Milter
November 4, 2009 at 3:02 am
Try to use TOAD for SQL Server that has this functionality built in.
Ya. I have checked TOAD fro SQL Server.
Thanks for the reply.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply