Jasper Smith's SSRS Scripter

  • Anyone happen to have this tool handy? I used in the past to successfully migrate a 2005 SSRS instance to 2208 R2 and am in a similar boat now.

    Sadly it looks like http://www.sqldbatips.com no longer exists and is now hosted on sqlblogcasts.com. There are posts on the new site about the tool, but all of the links still point back to:

    http://www.sqldbatips.com/showarticle.asp?ID=62

    I investigated the new MS SSRS Migration Tool. Looks promising but there are several restrictions which prevent me from using it:

    - First and foremost, source and target SSRS instances must be SSRS 2008 R2 or newer

    - The target server must be configured in SharePoint integrated mode

    Any help would be appreciated, thanks!!

    DH

  • P.M.'d you.

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • Thanks to MM for helping me out!

  • darkhelmutis (4/8/2013)


    Thanks to MM for helping me out!

    Please PM me as well, as I've been trying to locate this tool for a few days now.

  • If someone can forward me the info, I would appreciate it. Just switched jobs and love this tool.

  • May I have it as well?

  • Can someone please pass on a copy of RSScripter. Needed urgently. Help would be greatly appreciated.

  • Hi,

    I am also looking for this tool today - have used it many many times in the past. I'm now on SSRS 2012 however - will it still work?

    Would be be great if someone could make it available for me.

    How strange such an amazing tool can just vanish from the web - wonder if Microsoft have bought it up...

    Cheers!

    JayK

  • I'm in the same situation as everyone else. If someone can tell me where I can get this tool from it would be greatly appreciated.

    Thanks

  • I know this is an old post, but I thought I would add what I found. I went to archive.org, and pasted in http://www.sqldbatips.com/showarticle.asp?ID=62 into the WayBackMachine and found the site. I then download the zip file from the cached copy of the website. Archive.org, a great project.

  • jhood-

    Thanks for the followup. I got a lot of great responses to this, including the one that pointed to the fact the SSRS scripter tool was rolled up into a larger project. Go figure!

    I've used this before and it is the closest thing I know of to 'easily' merge and migrate SSRS instances. As much as Microsoft pushes SSRS as an enterprise reporting tool (and it is pretty good at that creating, serving reports), it is awful from a management perspective. I hope they improve that part of it moving forward. It should be easier to merge, split, migrate, and move an SSRS instance. However, I have heard ramblings that perhaps SSRS is going the way of the dinos...but no official confirmation!

    Take care,

    DH

  • Hi,

    I have this tool but I have spent a day and still can't get it to work. I am able to select what I want to script and generate the script. I copy the folder over to the destination reporting server and run the "RS Scripter Load All Items.cmd" and in the log I keep getting the error below. I have many more reports to do but I just wanted to start small for the test. Both source and destination servers are SQL 2008R2.

    Reporting Services Scripter Load Log 2.0.0.17

    Starting Load at Mon 09/23/2013 14:56:29.95

    SCRIPTLOCATION = C:\RSScripterzip\

    REPORTSERVER = http://localhost/ReportServer

    BACKUPLOCATION =

    SCRIPTLEVEL = SQL2008

    TIMEOUT = 60

    RS = "C:\Program Files(x86)\Microsoft SQL Server\100\Tools\Binn\RS.EXE"

    Running script "C:\RSScripterzip\OGS\Emailed\Weekly\ActiveProductCount.rdl.rss"

    The system cannot find the path specified.

    Running script "C:\RSScripterzip\OGS\Emailed\Weekly\CashAndSales.rdl.rss"

    The system cannot find the path specified.

  • Not sure, starting with the obvious: does that path reported in the error exist? Seriously, cut and paste it into explorer to make sure there isn't a typo? That is all I can think of right now.

  • Which path, the report server path or the path to the reports copied by the script? When I type in the localhost\reportserver the reporting server page comes up...

  • Viewing 15 posts - 1 through 15 (of 35 total)

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