January 25, 2013 at 6:13 am
Hello all,
My company currently uses Visual Studio 2005 and is thinking of upgrading to Visual Studio 2012. I've created A LOT of reports in Visual Studio 2005. My question is, if we go ahead and upgrade, will I have to re-create all my reports in the new version? Or, if upgrade is done correctly, would I be able to access all my existing reports?
Is the upgrade difficult?
Sorry for the simplicity of these quesion but thanks for taking the time to read.
MB
January 25, 2013 at 6:17 am
You should use the right version of VS for the version of SSRS.
So if your using SSRS 2005, you use BIDS 2005 built in VS2005
SSRS 2008 or SSRS 2008R2, you use BIDS 2008 built in VS2008
SSRS 2012, you use SSDT built in VS2010
Each edition of SSRS has a specific XML for RDL's so best to use the correct version of SSRS with the correct report template
January 25, 2013 at 6:39 am
So is that a no? Meaning if I go through with the upgrade, I cannot access my exisitng reports and they will all need to be re-created?
January 25, 2013 at 6:43 am
If your going to upgrade your report server to SQL 2012, then you can upgrade your reports to VS 2010 but no higher.
If your not planning on upgrading your SSRS server, then don't upgrade your report solutions.
Visual Studio 2012 does not support BI projects (SSIS / SSRS / SSAS)
January 25, 2013 at 7:04 am
Ok, I think I understand...
If we upgrade to SQL Server 2012, then we should upgrade reporting services to 2010. Got it.
So we're currently running with SQL Server 2005 with 2005 reporting services.
After the upgrade, the reports created in ssrs 2005 should run seamlessly in ssrs 2010?
Again, thanks for drilling this home. Im learning something today.
January 25, 2013 at 7:10 am
There is no SSRS2010, SSDT (SQL Server Data Tools) is built using Visual Studio 2010 is the means to create reports for SSRS 2012
SSRS 2008 and SSRS 2008R2 use BIDS (Business Intelligence Development Studio) is built in Visual Studio 2008
SSRS 2005 uses BIDS which is built in Visual Studio 2005
So if you use SSRS 2005, you use BIDS from the SQL 2005 Start Menu
SSRS 2008 or SSRS 2008 R2, you use BIDS from the SQL 2008 Start Menu
SSRS 2012, you use SSDT from the SQL 2012 Start Menu
Each edition of BIDS or SSDT create a different XML base for reports, so when you upgrade your reports from SSRS 2005 to SSRS 2012, you effectively change the underlying structure of the report, meaning it wont open in a lower edition of the software.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply