Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

Using Team Foundation Service

Team Foundation Service (TFS) is the “cloud” version of Team Foundation Server 2012.  Up to 5 users are free, plus for a limited time all use is free (more info).

Below is my experience setting up Team Foundation Service and uploading my projects:

  1. Sign up for free here.  You will need to use a Windows Live account.  You will create your own TFS website, something like
  2. Read Connect Visual Studio to TFS where you will create a team project via your TFS website and then connect Visual Studio to your team project. If using Visual Studio 2010, to connect to TFS follow this.  Note to use TFS with Visual Studio 2010, you need to have Visual Studio 2010 SP1 installed as well as this fix
  3. If using Visual Studio 2012, follow Upload your code and then follow Check files in and out
  4. If using Visual Studio 2010, create a workspace mapping.  You should make the Local Path the location of your existing code.  See Create and Work With Workspaces.  I have a bunch of existing projects that I want to add to source control, so I want to add those local files to version control via Visual Studio 2010.  Check out “To add a solution to version control” on Add Files to Version Control
  5. That’s it!  Very simple to use, and I can now access my source code anywhere.  Plus no worries about setting up a server or VM to host TFS, installing TFS, backing it up, etc
  6. TFS is updated frequently with new features, so check out Team Foundation Service updates.  Enter your request for a new feature at Visual Studio UserVoice
  7. Note that Team Foundation Service does not have all the features in Team Foundation Server, such as Federated Identity Management, Lab Management, Detailed Reporting and Analytics, and On-Premises Server Integration

More info:

TFS Heads to the Clouds

Installing Team Foundation Server (TFS) 2012

Managing Schemas And Source Control For Databases

Video Taking Your Application Lifecycle Management to the Cloud with the Team Foundation Service

Continuous deployment of SSDT database projects to Windows Azure using Team Foundation Service

TFS 2012: Comparison of Team Foundation Server’s Edition

Team Foundation Server vs. Team Foundation Service


Leave a comment on the original post [, opens in a new window]

Loading comments...