Anyone know how I can copy the user reports (and model) someone has created to point at another database (same schema).
I don't really want to recreate the data model becuase (a) it's really complicated and (b) the previous developer added lots of friendly column names.
Copying reports is pretty easy if you have the original RDL/SMDL files; simply redeploy/upload it again, and change its name/location/datasource.
If you don't have the original RDL/SMDL files, you'll need to extract these from the report server and redeploy. The easiest way to do this is via an rs.exe script.
The following describes how to copy reports from one server to another, but the same principles apply when copying reports etc. to the same server (from http://msdn.microsoft.com/en-us/library/ms159720.aspx):
You can write scripts that duplicate a report server environment on another report server instance. Deployment scripts are generally written in Visual Basic and then processed using the report server script host utility. The following list describes the steps for migrating reports from one server to another.
- Set your script variable to the URL of the source report server.
- Use the GetReportDefinition and GetProperties methods to retrieve the report definition and the properties of the report.
- Set the URL to point to the destination server.
- Use CreateReport method, passing the properties returned from GetProperties and the report definition returned by GetReportDefinition.
Once you've copied the reports, you can change the data source for the reports and the model (assuming you haven't done it programmatically via the RSS script):
If they're using a Shared Data Source, it'll be easier to leave them as they are and change the server it references, without touching the reports and model, so change the second point above to "Find the shared data source they reference"
I wrote a tool to do the same. Maybe it will help you too.
Take a look at: http://code.google.com/p/reportsync/
