Visual Studio 2013 SSDT – Support for SQL Server 2008 R2?

I have a question for someone out there who has Visual Studio 2013 – SSDT installed… I know that we cannot deploy SSIS packages to a SQL Server version less than 2014, what about SSRS reports? Everyone on my team except the database guys have been using VS2013 for some time now. I want to upgrade too!!! If I convinced the business to upgrade the SSIS servers to 2014, we would still need to support SSRS reports in 2008R2 (because of SharePoint 2010). Arggg… Leave it to Microsoft to leave the database developers behind (again). A new version of Visual Studio is out for preview and I don’t want to be two versions behind.

Can someone please check to see if you can deploy an SSRS report to a 2008 R2 server using Visual Studio 2013? I know it’s a long shot. Otherwise, I’ll have to go through the massive 2013 install just to have my dreams crushed when it doesn’t work out..

  • Right code to retrieve data from sql server database
  • SQL Server Management Studio crashes after opening or creating database diagram
  • How do I remove non-breaking spaces from a column in SQL server?
  • Escape double quotes in SQL 2005/2008
  • SQL Server: preventing dirty reads in a stored procedure
  • sql server execute as permission errors in trigger
  • Thanks All!

    One Solution collect form web for “Visual Studio 2013 SSDT – Support for SQL Server 2008 R2?”

    SSDT-BI 2014 for VS 2013 can support SSRS 2008 R2. It just can’t support SSIS 2008R2. Please see the blog below:

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.