Post reply

How to consolidate SSRS 2008?

  • July 17, 2010 at 1:52 am

    #235333

    Hi,

    I have two SSRS 2008 physical box. I would like to know How I could consolidate in one physical box.

    Thanks.

    Ram
    MSSQL DBA

  • July 17, 2010 at 1:58 pm

    #1194575

    Hi Reo,

    I would say your options are:-

    1) Run the two Reporting Services servers as separate virtual machines on a single physical host.

    2) Run two separate Reporting Services instances on the one physical server.

    3) Run one Reporting Services instance on the one physical server and migrate all your reports from the two existing servers to the one.

    Without knowing the specific details of your environment, I'd say that option 3 is the obvious choice. You will also only need 1 SQL Server licence for this option instead of two.

  • July 21, 2010 at 3:31 am

    #1196030

    Hi,

    Actually I would like to consolidate/merge two instances of SSRS into one instance of SSRS.

    What will be the best way to merge two Instances of SSRS? How I will migrate Reports, Folders, Users, Permission, Roll from One instance to another?

    Ram
    MSSQL DBA

  • July 21, 2010 at 3:37 am

    #1196031

    I think that the quickest and easiest way of migrating all your reports from one SSRS instance to another is to use this excellent (free) tool:-

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

    I've seen other techniques, like for example using MSBUILD, but the tool above is the easiest and the best way to do this imho.

    Good luck with your migration.

Viewing 4 posts - 1 through 3 (of 3 total)

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