How to transfer reports built using report builder from one server to another
Hi Folks,
The subject says it all. We have a number of reports built using Report Builder and want to move some of the individual reports to another server. Unfortunately we can't find a reasonable solution that doesn't involve wiping over anything.
Does anyone have any suggestions?
Thanks,
Jes
The subject says it all. We have a number of reports built using Report Builder and want to move some of the individual reports to another server. Unfortunately we can't find a reasonable solution that doesn't involve wiping over anything.
Does anyone have any suggestions?
Thanks,
Jes
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you are using the MSSQLRS (Business Intelligence Development Studio) you will note that all of the documents are simply XML documents that have the "rds" or "rdl" extension. You can simply copy them from one project to another by doing the following:
1. Create/Open a Target Project that's on the target SQL Server.
2. In the Solution Explorer Right Click the Reports Folder and select "Add > Existing Item..."
2. Copy the files from the Source Project bin folder
3. Test
NOTE: Report ID's are GUIDS. As long as they are unique, you're good.
1. Create/Open a Target Project that's on the target SQL Server.
2. In the Solution Explorer Right Click the Reports Folder and select "Add > Existing Item..."
2. Copy the files from the Source Project bin folder
3. Test
NOTE: Report ID's are GUIDS. As long as they are unique, you're good.
ASKER