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

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

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 2:12 AM
Points: 193, Visits: 552
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.
Post #950639
Posted Monday, July 12, 2010 1:11 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:16 AM
Points: 2,897, Visits: 5,982
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.


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