locked
Synching reports in reporting Server RRS feed

  • Question

  • Hi,

    We have two reporting servers across two different domains, every time I need to deploy a report I must deployed on both servers

    Is there a way or some tool that can synch reports between two servers?






    • Edited by ssitb Thursday, October 11, 2012 8:10 AM
    Thursday, October 11, 2012 7:47 AM

Answers

  • Hi,

    Check out this option ....with the command prompt utility and rss files. Look into the following link for more details:

    http://msdn2.microsoft.com/en-us/library/ms162839.aspx

    with multiple rs command lines in one single batch file (.bat) and then execute that file for deploying to multiple servers.

    Cheers,

    Arun Gangumalla

    • Proposed as answer by Syed Qazafi Anjum Friday, October 12, 2012 8:58 AM
    • Marked as answer by Fanny Liu Wednesday, October 17, 2012 3:19 AM
    Thursday, October 11, 2012 12:31 PM
  • Hi Ssitb,

    In Report Designer in Business Intelligence Development Studio, we can specify the report server as well as folders for reports and shared data sources so when publish the items in a project. We can create multiple named sets for these project properties to conveniently switch between different report servers or settings. However, there is only one active configuration at one time. So we have to deploy the project to Report Servers one by one.

    For more information about set deployment properties, please see:
    http://msdn.microsoft.com/en-us/library/ms155802(v=sql.100).aspx

    Personally, I recommend you that submit a wish at https://connect.microsoft.com/SQLServer/. If the requirement mentioned by customers for many times, the product team may consider to add this feature in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided.

    Regards,
    Fanny Liu


    Fanny Liu

    TechNet Community Support

    • Proposed as answer by Syed Qazafi Anjum Friday, October 12, 2012 8:58 AM
    • Marked as answer by Fanny Liu Wednesday, October 17, 2012 3:19 AM
    Friday, October 12, 2012 7:01 AM

All replies

  • Hi,

    Only short way of doing so is to either upload the updated report directly on report manager link of both servers or else

    you can change the reportserver link (report project menu > Project > Project properties > TargetServerURL ) on the report project file to deploy directly from Project solution it self.

    Cheers,

    Arun Gangumalla

    Thursday, October 11, 2012 10:42 AM
  • But that would still require deploying the same report twice manually.

    Is there a way to deploy once on both server on same time.


    Samer.Salameh

    Thursday, October 11, 2012 11:49 AM
  • Hi,

    Check out this option ....with the command prompt utility and rss files. Look into the following link for more details:

    http://msdn2.microsoft.com/en-us/library/ms162839.aspx

    with multiple rs command lines in one single batch file (.bat) and then execute that file for deploying to multiple servers.

    Cheers,

    Arun Gangumalla

    • Proposed as answer by Syed Qazafi Anjum Friday, October 12, 2012 8:58 AM
    • Marked as answer by Fanny Liu Wednesday, October 17, 2012 3:19 AM
    Thursday, October 11, 2012 12:31 PM
  • Hi Ssitb,

    In Report Designer in Business Intelligence Development Studio, we can specify the report server as well as folders for reports and shared data sources so when publish the items in a project. We can create multiple named sets for these project properties to conveniently switch between different report servers or settings. However, there is only one active configuration at one time. So we have to deploy the project to Report Servers one by one.

    For more information about set deployment properties, please see:
    http://msdn.microsoft.com/en-us/library/ms155802(v=sql.100).aspx

    Personally, I recommend you that submit a wish at https://connect.microsoft.com/SQLServer/. If the requirement mentioned by customers for many times, the product team may consider to add this feature in the next SQL Server version. Your feedback is valuable for us to improve our products and increase the level of service provided.

    Regards,
    Fanny Liu


    Fanny Liu

    TechNet Community Support

    • Proposed as answer by Syed Qazafi Anjum Friday, October 12, 2012 8:58 AM
    • Marked as answer by Fanny Liu Wednesday, October 17, 2012 3:19 AM
    Friday, October 12, 2012 7:01 AM