July 12, 2010 at 3:47 am
What are the procedures of migration a Report Definition File to another server ?
I need to migrate a Report from my UAT server to PRD server.
(1)Generated a Report Definition File in the UAT server.
(2)Copy this rdl file to the PRD server.
(3)Modify these portion of the rdl file :
... ... ...
<ConnectString>Data Source=the PRD machine name;Initial Catalog=hkprovision</ConnectString>
... ... ...
<rd:ReportServerUrl>http://the PRD machine name/ReportServer</rd:ReportServerUrl>
... ... ...
(4)Upload this rdl file onto the PRD server through its Report Manger
Am I correct ?
Please point out if there are somethings I missed.
Thanks.
July 12, 2010 at 1:11 pm
yup, that's basically how you'd do it, but if you have a fair number of reports it could become a bit of a pain. I'd suggest you look into the Reporting Services Scripter available here: http://www.sqldbatips.com/showarticle.asp?ID=62
It's a great free tool for scripting the migration of reports from one server to another, just like you are doing with UAT/Prod etc...
-Luke.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply