This being the day of the Visual Studio 2012 Virtual Launch, I thought I would actually try out the product, which has been sitting in my downloads directory for several weeks.
I ran the installer yesterday, and it took a whopping two hours to install, finishing one minute before I had to leave to catch my light rail train home!
I started off this morning by trying to connect to TFS 2010, and was pleasantly surprised to find that it worked. I have TFS 2012, but I don’t have time at the moment to install it and migrate.
Next I tried opening a VS 2010 solution containing a mix of projects. There was another surprise, and not a pleasant one. Three of the projects — one SSAS, one SSIS, and one SSRS — failed to load, the error being “Not supported.” I Googled around a bit and came across this blog post. It seems Microsoft hasn’t gotten around to supporting these project types via SSDT for VS 2012.
OK, done with VS 2012. Back to work!
Update: a new version of SSDT has been released. I haven’t had an opportunity yet to see if it adds the needed compatibility. You can read about the update here on Jen Stirrup’s BI blog.
Update: the new SSDT release did not address VS 2012 compatibility with BI projects. For those like me that do not need the new features in VS 2012, that means sticking with VS 2010 until such time as MS does something about it. For those that do need the new features, it means using VS 2012 for some things, VS 2010 for others, and presumably VS 2008 for yet others. SQL Server SSDT is staying one version behind Visual Studio.