Copying a SQL Report from One Server to Another
Posted on 2013-01-25
I created a report in SQL Reporting Services (SSRS) 2008 using the Business Intelligence Development Studio on a test server, and it works very well.
I want to copy this report to a live server. Would this be as simple as:
(a) e-mailing the .rdl and .rds files to myself through Web Outlook,
(b) downloading those two files onto a location on the live server,
(c) opening Business Intelligence Development Studio on the live server,
(d) choosing to create a "blank" Report Project on the live server, and
(e) "adding" the .rdl and .rds files to Solution Explorer on the live server by right-clicking and choosing "Add...Add Existing Item"?
My biggest concern has to do with copying the shared data source that I used on the test server (i.e. the .rds file). Can I copy this, or do I have to recreate this shared data source?