Best Practices For BI Environments ( Development, Test and production)


  • Hi, 

    We are developing a BI solution using Microsoft 2012 BI, and we are wondering  if there is a best practices to manage Dev, Test and production environements for SSIS, SSAS and SSRS regarding these points: 

    - To Have a versioning system for Source Code files.

    - How To Synchronize SSIS packages, SSAS Cubes And SSRS reports (Is writing Script Files the main solution ? Or there is another solution).

    Thank you in advance for your answers.

    Wednesday, November 20, 2013 4:18 PM


  • Hello,

    I don't fully understand the first question in your post. Could you please explain it more detail? What's the expected requirement?

    The second question is related to SSIS package, SSAS cubes and SSRS reports deployment. I will explain them with more detail.


    Elvis Long
    TechNet Community Support

    • Marked as answer by B.simo Thursday, November 21, 2013 1:22 PM
    Thursday, November 21, 2013 8:49 AM

All replies