Copying SQL Reports from Prod to NonProd Server

Question

Copying SQL Reports from Prod to NonProd Server

SQL_Hunt

SSC-Dedicated

Points: 33518
More actions
October 21, 2016 at 10:11 am

#331493

Hello Experts
I have to Export/copy all the folder and reports (rdl) from Prod to Non Prod as for the purpose of user tests.
Please let me know a convenient way to do the task as I can do it manually but doing it one by one is a time consuming process/task.
Thanks
Sourav
Thanks.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90860 More actions · Answer 1

SQL-DBA-01 (10/21/2016)
Hello Experts
I have to Export/copy all the folder and reports (rdl) from Prod to Non Prod as for the purpose of user tests.
Please let me know a convenient way to do the task as I can do it manually but doing it one by one is a time consuming process/task.
Thanks
Sourav

I still use Reporting Services scripter for these things. You can find information, download links at:

https://sqlserverfinebuild.codeplex.com/wikipage?title=Install%20Reporting%20Services%20Scripter

Another option would be that there are powershell scripts available if you search on that as well.

Sue

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 2

Thanks Sue..There are so many versions I can see by FineTune.

Now, do I need to install/use the one based on the SQL Edition? I found my sql insrance is sQL 2012. Or can I use higher editions as well?

Thanks.

Sue_H SSC Guru Points: 90860 More actions · Answer 3

SQL-DBA-01 (10/21/2016)
Thanks Sue..There are so many versions I can see by FineTune.
Now, do I need to install/use the one based on the SQL Edition? I found my sql insrance is sQL 2012. Or can I use higher editions as well?

Yes, just use the 2012 download. Great tool if you do much with administering SSRS and moving things between environments.

Sue

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 4

Are you referring to this article?

http://web.archive.org/web/20120830141644/http://www.sqldbatips.com/showarticle.asp?ID=62

Thanks.

Sue_H SSC Guru Points: 90860 More actions · Answer 5

No that's just the original bits from the guy who first wrote the tool.

Go here: https://sqlserverfinebuild.codeplex.com/releases/view/625469

and select SQL2012 FineBuild.zip

Sue

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 6

These are all SQL Build scripts...Not sure out of them which one is specifically for Reporting

Thanks.

Sue_H SSC Guru Points: 90860 More actions · Answer 7

There is a way to break them out but from what I can see, it's just the original RSScripter with no updates.

It works through 2012 though which should work for you. Grab it from that archive post link you have of Jasper's site:

http://web.archive.org/web/20120830141644/http://www.sqldbatips.com/showarticle.asp?ID=62

If you end up with a report server of a higher version, take a look at the Reporting Services Migration Tool. It generates Powershell scripts to do the same. If you're interested, you can download that tool from here:

https://www.microsoft.com/en-us/download/details.aspx?id=29560

Sue