Эдуард Кабринский - Vsts on premise - Eduard Kabrinskiy <h1>Vsts on premise</h1> <p>[youtube]</p> Vsts on premise <a href="http://remmont.com">English news</a> Vsts on premise <h1>The Blog of The Hybrid DBA</h1> <h2>I like to make stuff go</h2> <h1>Installing a Visual Studio Team Services private build agent hosted On-Premises</h1> <p>This blog post is about a situation where I use Visual Studio Team Services (VSTS) to build/deploy my DEMOs. Those DEMOs are what I use to illustrate Continuous Integration & Continuous Delivery (important parts of that thing called DevOPs).</p> <p>I use my own personal VSTS account so that I am not showing anything commercially sensitive.</p> <p>One thing with using a basic account is that you only get 240 build minutes per month. These builds are utilising the hosted build agents in Azure.</p> <p>This works great ? up until I have 4 DEMOs that are different and require testing before I present them. In May 2017 I had 4 DEMOs to conduct:</p> <p>Code Camp Christchurch on May 13th where I was speaking twice: (VSTS and Azure DEMO and SQL Server Data Tools DEMO) both of which would be using VSTS.</p> <p>A webinar for the DBA Virtual Chapter on May 18th which was on ?DevOPs and the DBA?.</p> <p>SQL Saturday Brisbane on May 27th ? mostly the same DEMO as the DBA VC.</p> <p>Whilst the DEMOs themselves would only use 12 minutes of build time ? the preparation of them would push me over the limit. I also wanted to try quite a few new things related to SSDT, DACPACs and other things related to SQL Azure.</p> <p>You can use your own hosted (known as ?private ?) build agent and connect to up to VSTS ? so long as it has access and the right tools installed on it?.</p> <p>That is another reason to use your own hosted agent ? you may have specific software required for your build(s). In my case I would be doing a lot of builds relating only to SQL Server, Azure SQL Database and associated tools.</p> <p>Oh yeah ? VSTS allows one free private hosted agent.</p> <p>So I have created a dedicated build agent just for my SQL Server activities.</p> <p>Here is a step by step guide to installing a private hosted build agent. For authentication I will be using a Personal Access Token (PAT) for the agent to authenticate to VSTS.</p> <p style="clear: both"><ol> <li>Log into VSTS and from your home page, open your profile. Go to your security details.<img style="float: left; margin: 0 10px 5px 0;" src="https://hybriddbablog.files.wordpress.com/2017/04/vsts_agent_0.png" /></li> <li>Configure the PAT ? for the scope select <strong>Agent Pools (read, manage)</strong> and make sure all the other boxes are cleared<img style="float: left; margin: 0 10px 5px 0;" src="https://hybriddbablog.files.wordpress.com/2017/04/vsts_agent_0_1.png" /></li> <li>Save the token somewhere as you will need it when installing/configuring the agent on the on-premises server.</li> <li>Log on to the machine using the account for which you have permissions to install software and also access VSTS</li> <li>In your web browser, sign on to VSTS, and navigate to the <strong>Agent pools</strong> tab: https://<your_account>.visualstudio.com/_admin/_AgentPool</p></ol> <p style="clear: both"><img style="float: left; margin: 0 10px 5px 0;" src="https://hybriddbablog.files.wordpress.com/2017/04/vsts_agent-e1493027326605.png" /></li> <li>Click <strong>Download agent</strong>.</li> <li>On the <strong>Get agent</strong> dialog box, click <strong>Windows</strong>.</li> <li>Click the <strong>Download</strong> button.</li> <li>On the server ? extract the ZIP file in a directory and run config.cmd<img style="float: left; margin: 0 10px 5px 0;" src="https://hybriddbablog.files.wordpress.com/2017/04/vsts_agent_3-e1493027437373.png" /></li> <li>Fill in details as required ? you will use the PAT token from step 2/3 above:<img style="float: left; margin: 0 10px 5px 0;" src="https://hybriddbablog.files.wordpress.com/2017/04/vsts_agent_4.png" /></li> <li>Go back into VSTS and you will now have a new hosted agent:<img style="float: left; margin: 0 10px 5px 0;" src="https://hybriddbablog.files.wordpress.com/2017/04/vsts_agent_5.png" /></li> <li>For the particular project ? go into Settings | Agent Queues and choose the existing pool that will have the newly installed private agent in it.<img style="float: left; margin: 0 10px 5px 0;" src="https://hybriddbablog.files.wordpress.com/2017/04/vsts_agent_6.png" /></li> <li>Next we want to associate our build steps with this queue ? so edit your build definition and choose the Agent Queue from above:<img style="float: left; margin: 0 10px 5px 0;" src="https://hybriddbablog.files.wordpress.com/2017/04/vsts_agent_7.png" /></li> <li>Now the REAL fun begins ? let?s queue a build. <br /><img style="float: left; margin: 0 10px 5px 0;" src="https://hybriddbablog.files.wordpress.com/2017/04/vsts_agent_8.png" /></li> <li>And of course it works the first time?.<img style="float: left; margin: 0 10px 5px 0;" src="https://hybriddbablog.files.wordpress.com/2017/04/vsts_agent_91.png" /></li> <li>If we now look in generated artifact we will have our desired result ? a DACPAC file<img style="float: left; margin: 0 10px 5px 0;" src="https://hybriddbablog.files.wordpress.com/2017/04/vsts_agent_10.png" /></li> </ol> </p> <p>That we can now use VSTS to deploy out to our Azure SQL Database (and also on-premises SQL Server).</p> <p>Which is the basis for another blog post?..</p> <h2>Vsts on premise</h2> <h3>Vsts on premise</h3> <p>[youtube]</p> Vsts on premise <a href="http://remmont.com">World news</a> Vsts on premise <h4>Vsts on premise</h4> This blog post is about a situation where I use Visual Studio Team Services (VSTS) to build/deploy my DEMOs. Those DEMOs are what I use to illustrate Continuous Integration & Continuous Delivery (important parts of that thing called DevOPs). I use my own personal VSTS account so that I am not showing anything commercially sensitive.… <h5>Vsts on premise</h5> Vsts on premise <a href="http://remmont.com">Vsts on premise</a> Vsts on premise SOURCE: <h6>Vsts on premise</h6> <a href="https://dev-ops.engineer/">Vsts on premise</a> Vsts on premise #tags#[replace: -,-Vsts on premise] Vsts on premise#tags# Kabrinskiy Eduard news
