Well, my good mates at Microsoft have managed to leave us developers in a bit of a lurch, AGAIN.
The situation this time is that Visual Studio 2010 does not have support for SQL Server 2008 R2 in there yet, so we are forced to use BI Development Studio (BIDS) 2008 with SQL 2008 R2.
What makes this painful is that VS2010 should support everything, but now we are forced to work in 2 different environments. Additionally, BIDS 2008 will not work with Team Foundation Server 2010 out of the box.
In an even funnier situation, we have to use VS2010 to version control the SQL 2008 R2 databases, as this cannot be done in BIDS.
I hate to say this, but Microsoft seems to have dropped the developer ball since Bill left.
Anyways, there is a solution, but not a simple one sadly. The post here describes how to get this working.
I already had BIDS2008 installed with VS2010 side-by-side. The steps I followed to get this working were:
- Install VS 2008 Team explorer (download here)
- Install VS 2008 SP1 (download here)
- Install VS2008 SP1 Forward compatibility Update For TFS2010 (download here)
- Update registry entry as per this blog (Medo Blog) HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\TeamFoundation\Servers with the URL to your Project Collection in TFS so that BIDS can connect to TFS properly. URL looks like http://TFSServer:8080/tfs/collection (assuming default install paths, virtual directories, etc.). Just add a new string type (REG_SZ) with name = tfsservername and value = URL (as above).
Once that is done, open BIDS and connect to TFS, the server should already be there when you go to connect in Team explorer 2008.
VS2010 connects natively (possibly dependent on VS version) to TFS so we can version control the databases, but it sure would be a lot nicer to just have all this stuff work OOTB like it should, re-align SQL and VS releases if you need to Microsoft, I’d be happier to wait for an aligned release than deal with this mess.
Happy BI Development