locked
SSRS Reports migration and management between environments RRS feed

  • Question

  • Hi everyone,

    I've bingoogled a lot but cannot find much on how folks manage the progression of SSRS reports from DEV > TEST > USER > PROD

    I can see that you COULD manage this all from within VS however then all the control is in the developers hands and even though you can control access with permissions and stuff, its not very user friendly to provide a tester or business area manager or project manager with VS just so they can publish reports as they are approved...

    Are their any such tools to manage migration between ssrs servers or something that you could have a user test a report and then do something like "approve/promote" it to the next environment, or is this something we would need to create ourselves?

    I can see that there are a few things that allow PROJECTS to be migrated (powershell scripts and something about octopus deploy) but these all seem to be too "big" for our organisation - we generally develop reports as a "logical group" (project) but migrate them individually or in VERY small groups (5 is probably the maximum), however keeping tabs on what report is at what version in what environment is causing our DBA massive migranes...

    Maybe there is something we can do from TFS or perhaps we need to build a utility app?

    Any help/suggestions appreciated...


    - sure I'm noJedi but that's no reason to stop trying to make stuff levitate! -



    • Edited by noJedi Thursday, August 13, 2015 3:59 AM
    Thursday, August 13, 2015 3:57 AM

Answers

  • Nothing is native to the tool to allow this.  However, it gets managed in my environment through custom code that was written to work against the SSRS API's.

    https://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010(v=sql.120).aspx

    With that it's possible to deploy items such as resources (i.e., images), reports, linked reports, etc.  

    • Marked as answer by noJedi Monday, August 17, 2015 12:28 AM
    Thursday, August 13, 2015 4:04 PM
  • Hi noJedi,

    In Reporting Services, there is no such tool can migrate reports between report servers in the way like you required.

    Currently, if we want to migrate reports between two report servers, what we can do is to export reports from the source report server then import them to target report server using Reporting Services Migration Tool or Reporting Services RSS script. However, we can’t control migration process in an intelligent way. So for your requirement, it can’t be achieved currently.

    Reference:
    Migrating Content Between Report Servers
    Sample Reporting Services rs.exe Script to Copy Content between Report Servers

    If you have any question, please feel free to ask.

    Best regards,
    Qiuyun Yu


    Qiuyun Yu
    TechNet Community Support





    Friday, August 14, 2015 6:24 AM

All replies

  • Hi noJedi,

    Moving the Report Server Databases to Another Computer: http://technet.microsoft.com/en-us/library/ms156421.aspx
    Configuring and Managing Encryption Keys: http://technet.microsoft.com/en-us/library/ms156274.aspx
    Create a Report Server Database (Reporting Services Configuration): http://technet.microsoft.com/en-us/library/ms157300.aspx

    Kindly have a look at the below link to see what to backup for migration

    http://msdn.microsoft.com/en-us/library/ms155814.aspx


    Please Dont forget to mark as answer. It helps others to find relevant posts to the same question. Milan Das


    • Edited by Milan Das Thursday, August 13, 2015 4:05 AM
    Thursday, August 13, 2015 4:04 AM
  • Hi Milan,

    I'm actually wanting to migrate the reports (RDL files?) in a structured/controlled way, not MOVE everything iwth backup/restore/migration which is what your links seems to be explaining...

    Something that can help users to know whether a version of a report has been published, and allow managers to Approve a TEST report, and either push it from test-prod or at least flag it somehow so that some tech can export it from test and import it to prod...

    So either I'm misunderstanding your post, your misunderstanding mine, or I'm posting in teh wrong forum (assuming misleading context)...

    Am I missing something?


    - sure I'm noJedi but that's no reason to stop trying to make stuff levitate! -


    • Edited by noJedi Thursday, August 13, 2015 1:33 PM
    Thursday, August 13, 2015 1:30 PM
  • Nothing is native to the tool to allow this.  However, it gets managed in my environment through custom code that was written to work against the SSRS API's.

    https://msdn.microsoft.com/en-us/library/reportservice2010.reportingservice2010(v=sql.120).aspx

    With that it's possible to deploy items such as resources (i.e., images), reports, linked reports, etc.  

    • Marked as answer by noJedi Monday, August 17, 2015 12:28 AM
    Thursday, August 13, 2015 4:04 PM
  • Hi noJedi,

    In Reporting Services, there is no such tool can migrate reports between report servers in the way like you required.

    Currently, if we want to migrate reports between two report servers, what we can do is to export reports from the source report server then import them to target report server using Reporting Services Migration Tool or Reporting Services RSS script. However, we can’t control migration process in an intelligent way. So for your requirement, it can’t be achieved currently.

    Reference:
    Migrating Content Between Report Servers
    Sample Reporting Services rs.exe Script to Copy Content between Report Servers

    If you have any question, please feel free to ask.

    Best regards,
    Qiuyun Yu


    Qiuyun Yu
    TechNet Community Support





    Friday, August 14, 2015 6:24 AM