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?
I need to accomplish the same requirement to copy all reports,models,reports creted through report builder by client and they are about more than 800.
SO its not possible for me to redeploy all reports from production to new test dev server.
Link you specified above would work for me but still I was wondering if there is any other way to get it done wthout using any tool so please suggest me.I'm going to copy reports from Reporting server 2005 (Prod) to Reporting server 2005 (Dev).
Its pressing requirement need your assistance.
There is no gui utility from MS as of now but you can vote here if interested: