Post reply

Jasper Smith's SSRS Scripter

  • April 8, 2013 at 8:01 am

    #394538

    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

  • April 8, 2013 at 8:07 am

    #1604423

    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]

  • April 8, 2013 at 9:37 am

    #1604470

    Thanks to MM for helping me out!

  • April 8, 2013 at 11:09 am

    #1604507

    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.

  • April 9, 2013 at 5:43 pm

    #1605066

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

  • April 9, 2013 at 5:44 pm

    #1605067

    May I have it as well?

  • April 10, 2013 at 7:45 pm

    #1605451

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

  • April 10, 2013 at 11:46 pm

    #1605471

    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

  • April 12, 2013 at 10:24 pm

    #1606232

    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

  • April 29, 2013 at 12:25 pm

    #1610946

    Please check this - http://sqlserverfinebuild.codeplex.com/wikipage?title=Install%20Reporting%20Services%20Scripter

    Thanks!

  • June 7, 2013 at 10:04 am

    #1622124

    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.

  • June 7, 2013 at 11:05 am

    #1622138

    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

  • September 23, 2013 at 1:21 pm

    #1652450

    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.

  • September 24, 2013 at 11:43 pm

    #1652952

    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.

  • September 25, 2013 at 11:06 am

    #1653278

    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