I need to create a copy of my existing SSRS 2005 reports from SQL 2005 on my production server to my new test server. I am not sure how to port everything over. I may have to just redeploy the reports...that's fine with me, but just windering if there was a tool to tell SQL 2005 to create a separate non-related copy of everything in my current SSRS Production server to my new test server.
Also what's the best way to manage the dev vs. prod reports? If I'm developing a report on my dev server, the datasources will be pointing to that server. Come time to move it to production right now I've having to create another datasource and change all my datasets in a particular report to point to a datasource that points to my production server, then deploy. Is there a better and easier way to do this rather than switching all my datasets to the production server manually then deploying?
You can look into managing it through Management Studio and/or creating RS scripts.
Another option is to use the RS Scripter tool by Jasper Smith: http://www.sqldbatips.com/showarticle.asp?ID=62
-- Robert
No comments:
Post a Comment