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: Monday, September 12, 2016 10:37 PM
Points: 204, Visits: 604
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: Friday, September 2, 2016 12:24 PM
Points: 2,662, Visits: 6,095
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