I've used this tool before and it works well:http://code.google.com/p/reportsync/ Regards, -S
From: [email protected] To: [email protected] Subject: [mssms] RE: Backing up and restoring custom reports to new server Date: Mon, 8 Jun 2015 18:38:34 +0000 This is a pretty cool script for import/export of reports from Nickolaj Andersen http://www.scconfigmgr.com/2014/11/28/export-and-import-reports-in-configmgr-2012-with-powershell/ cheers Phil From: [email protected] [mailto:[email protected]] On Behalf Of Krueger, Jeff Sent: 08 June 2015 19:25 To: [email protected] Subject: [mssms] Backing up and restoring custom reports to new server Has anyone had experience with moving your site database to a different server and restoring your custom reports? Also does anyone do anything special for backing up their custom reports, or just rely on backing up the reporting DB? So the site restore to point at the new DB will take care of the canned reports, but we have a fair number of custom reports in an organized folder structure. Is it just a matter of restoring the reporting services database to the new server, or do we need to upload all the report definition files? It appears that custom reports are only stored in the reporting DB as binary data, I can’t find anywhere that the definitions are saved as a file. We have around 70 custom reports so downloading them off report server by hand would be a major pain. Jeff Krueger [email protected] Solutions Design Team IT - Henry Ford Health System CONFIDENTIALITY NOTICE: This email contains information from the sender that may be CONFIDENTIAL, LEGALLY PRIVILEGED, PROPRIETARY or otherwise protected from disclosure. This email is intended for use only by the person or entity to whom it is addressed. If you are not the intended recipient, any use, disclosure, copying, distribution, printing, or any action taken in reliance on the contents of this email, is strictly prohibited. If you received this email in error, please contact the sending party by reply email, delete the email from your computer system and shred any paper copies. Note to Patients: There are a number of risks you should consider before using e-mail to communicate with us. See our Privacy & Security page on www.henryford.com for more detailed information as well as information concerning MyChart, our new patient portal. If you do not believe that our policy gives you the privacy and security protection you need, do not send e-mail or Internet communications to us.
