February 20, 2018 at 5:27 am
All of my SSRS reports are currently on 2005 (develeoped on Visual Studio 2005). I just got access to a SSRS 2012 Report Server. I also installed SQL Server 2012 client tools and it installed Visual Studio 2010. Can I convert my SSRS 2005 reports to 2010 via Visual Studio 2010, and then deploy to the SSRS 2012 Report Server? Or do I need to install Visual Studio 2012 and convert the reports from 2005 to 2012?
February 22, 2018 at 4:24 pm
is250sp - Tuesday, February 20, 2018 5:27 AMAll of my SSRS reports are currently on 2005 (develeoped on Visual Studio 2005). I just got access to a SSRS 2012 Report Server. I also installed SQL Server 2012 client tools and it installed Visual Studio 2010. Can I convert my SSRS 2005 reports to 2010 via Visual Studio 2010, and then deploy to the SSRS 2012 Report Server? Or do I need to install Visual Studio 2012 and convert the reports from 2005 to 2012?
With the tools, it should have installed the Visual Studio 2010 shell to run SQL Server Data Tools (SSDT). And that works fine with SSRS 2012.
Once you open the reports in SSDT the reports will upgrade. Backup the reports before opening them in SSDT.
SSDT as well as SSMS are separate downloads now and you can use the latest versions.
In case you're interested, This is the link to more information and the latest downloads for SSDT:
Download SQL Server Data Tools
And here is some additional information on upgrading reports for SSRS 2012:
Upgrade Reports
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply