Friday, October 18, 2013

BI Development Studio 2008 integrate with TFS 2010

To let a SQL developer create BI projects for SQL 2008 and save the source in TFS 2010.

Installation

  • Download and install Team Explorer 2008 (This is an ISO file, if you don’t have an ISO image reader try installing Virtual clonedrive or a similar utility)
    • from the ISO image run setup.exe
      image
  • Download and install Visual Studio 2008 SP1 (This small installer will download the full installa and upgrade both VS2008 and Team Explorer 2008 to SP1, if the machine on which BI development Studio is installed, has no full internet access and rights, you may have to look for the full package download)
    • run the executable VS90…..exe
    • image
  • Download and install VSTS 2008 Forward Compatibility Update
    • image

Connecto to TFS

  • Start BI Developmnet Studio
  • In the menu View, select Other windows / Source control Explorer
  • image
  • In the menu Tools, select Connect to Team Foundation Server…
  • image
  • In the Connect window, Click on Servers…
  • image
  • In the Add/Remove window click on Add…
    • image
    • or if the TFS server is not the default root and you have to specify a site name, e.g. ‘Tfs’ then type the full url to the TFS site, ‘http://myserver:8080/tfs’
    • image
    • this will connect to the default TFS collection
    • If you need access to another collection, you need to add a new server connection and type the full name of the collection. e.g. if the collection’s name is ‘Accounting projects’ (with spaces) then the full url will to connect is ‘http://myserver:8080/tfs/Accounting%20projects’

No comments: