Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

procedures of a Report Definition File migration ? Expand / Collapse
Posted Monday, July 12, 2010 3:47 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 19, 2016 9:41 PM
Points: 204, Visits: 606
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.
Post #950639
Posted Monday, July 12, 2010 1:11 PM



Group: General Forum Members
Last Login: Monday, October 17, 2016 9:34 AM
Points: 2,662, Visits: 6,099
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:

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...


To help us help you read this

For better help with performance problems please read this
Post #950993
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse