Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Is SSRS RDL maintenance dependent on the version of BIDS that created it? Expand / Collapse
Author
Message
Posted Monday, March 17, 2014 10:14 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 8:22 AM
Points: 656, Visits: 939
I know this is true: To create or maintain an SSIS package, you must use the version of BIDS for that package. Eg. If an SSIS Pkg was developed in SQL 2005 BIDS, you must use SQL 2005 BIDS to maintain it. Optionally, you may convert/upgrade the SSIS Pkg to the version of SSDT or BIDS you have open.

Is the same true for SSRS RDL? If I have a report developed in SSRS BIDS 2005, (outside of converting it to SQL 2012) do I need to use BIDS 2005 to maintain it?


BT
Post #1551831
Posted Monday, March 17, 2014 9:15 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:24 PM
Points: 2,958, Visits: 2,564
Express12 (3/17/2014)
I know this is true: To create or maintain an SSIS package, you must use the version of BIDS for that package. Eg. If an SSIS Pkg was developed in SQL 2005 BIDS, you must use SQL 2005 BIDS to maintain it. Optionally, you may convert/upgrade the SSIS Pkg to the version of SSDT or BIDS you have open.

Is the same true for SSRS RDL? If I have a report developed in SSRS BIDS 2005, (outside of converting it to SQL 2012) do I need to use BIDS 2005 to maintain it?


As a general rule, yes - you probably do need to stick with the same version of BIDS to maintain your reports. If you open a report in a later version, the RDL will be upgraded and you probably will not be able to open it with an earlier version of BIDS. You could also have problem deploying the upgraded report to an earlier version of SSRS (not 100% sure of that but it is quite likely).



Post #1551984
Posted Tuesday, March 18, 2014 6:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 12:04 PM
Points: 5, Visits: 37
Express12 (3/17/2014)
I know this is true: To create or maintain an SSIS package, you must use the version of BIDS for that package. Eg. If an SSIS Pkg was developed in SQL 2005 BIDS, you must use SQL 2005 BIDS to maintain it. Optionally, you may convert/upgrade the SSIS Pkg to the version of SSDT or BIDS you have open.

Is the same true for SSRS RDL? If I have a report developed in SSRS BIDS 2005, (outside of converting it to SQL 2012) do I need to use BIDS 2005 to maintain it?



Yes, that is exactly true. You can upgrade your BIDS version to 2008, but you can't edit RDLs developed in SQL Server 2008 using BIDS 2005.
Post #1552151
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse