June 6, 2017 at 6:39 am
Hi all
We have two environments (DEV and PROD) and we need to transfer reports between the two.
I've found a Powershell script to download all the items (including the data sources) from our DEV environment to a folder but it's missing the report parts that we've created to standardise layouts, colour-schemes, etc.
I've attached the file (but had to rename it with a .txt extension instead of .ps1).
I've added the section for type 9 (which appear to be the report parts) but it's not firing.
Would someone be kind enough to have a look and let me know where I've gone wrong?
Also, I need to be able to do the reverse and upload it to our PROD environment (preferably en-mass to save uploading them one at a time).
I'll be the first to admit I know virtually nothing about Powershell so if someone could point me in the right direction I'd be obliged.
June 6, 2017 at 7:16 am
Not familiar with the PS method you posted, but I know there are alternatives to acomplish this:
https://github.com/dapaxx/reportsync
http://www.forrards.com/howtoeasilymigratessrsreportsbetweentwoservers/
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
June 30, 2017 at 8:16 am
Hi all
Thought I'd resurrect this thread rather than starting a new one.
I've managed to find a script to download all the .rdl files and the associated data sources, report parts, etc.
I've altered the script to take two parameters (the server to download from and the path to save the files to).
This download everything very nicely and keeps it in the relevant folders.
What I need to do now is find a method of uploading them in the same manner (in the relevant folders) back to a different server (the layout on the server needs to be the same) but I can only find methods of uploading the files one at a time.
Anyone any good at PowerShell that could help me out?
All help greatly appreciated.
::edit::
I've now attached the updated script.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply