The last 2 posts have seen use use TFS to build and deploy database models and SSIS packages. http://sqljoel.blogspot.com/2017/07/tfs-ssis.html
We are now going to turn our focus to SSRS. Just like applications, database models and SSIS our reports should get the same attention to detail when it comes to version control. Here we will build and deploy our SSRS reports through TFS. For ease of deployment, I have build a seperate project for each folder I want to see on our SSRS Server. Just as we had done with SSIS, when building our solution, we will need to use a command line task. We will call the devenv.com with the switches to /rebuild our solution.
Once built we can set up our release definitions. We will again call the devenv.com with our solution as an argument, but we will also use the /Deploy switch. My personal preference is to set up each environment in the configuration manager and call the configuration with the deploy switch.
If security is set correctly, at this point our SSRS Reports should be under version control in TFS and using the build and release definitions we have set up!
No comments:
Post a Comment