Link SQL SERVER 2008 and TFS

  • Hi Guys.

    We have SQL SERVER 2008 in our production environment , and we have put all of our strored procedures(from Production enviornment) into TFS.TFS and SQL SERVER environment are completley seperated from each other.I mean whenever we have any change in Stored Procedures in TFS,we need to run it manually on SQL SERVER side and vise versa .Is there any Manual or help that I can use to connect TFS and SQL SERVER 2008.so whenever I do any changes in TFS,it will automatically affect the SQL SERVER 2008.

    Thanks in advance.

  • Generically what you want to do is tie the check-in event in TFS Source Control to execute a build routine within Team Build. The build routine can do pretty much anything you choose...it can build and deploy a Visual Studio solution, run some unit tests, run an executable (e.g. sqlcmd...see where I am going with this?).

    The sqlcmd approach would set you off on building a homegrown solution to compile procs on some server

    after check-in which could get you where you want to go. If that's all you need, that should not be too difficult or time-consuming to produce. That said, if you want something a little more robust I would urge you to take a look at the Database Features in Visual Studio 2010. It may be a shock to your system to start developing for SQL Server in Visual Studio as opposed to SSMS but the functionality is awesome and it is fairly mature by now. The initial cut of Visual Studio for Database Professionals was for Visual Studio 2005.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply