SQL Change Automation and Jenkins on Linux
Lauther
Posts: 16 Bronze 2
Hi,
We are planning migrate our TFS to Jenkins, in TFS we have many projects which use Redgate SQL Change Build Automation plug-ins to build & deploy database structures and code.
The first approach is to install Jenkins on Linux, however, I have been reading and Jenkins basically what it does is to call the Redgate SQL Change Automation cmdlets via powershell. As far I know, the cmdlets can be installed on Windows only (first question here), being in this way, can Jenkins call the cmdlets installed in a remote machine (second question, no make much sense to me, but you never know) or the cmdlets must be installed in the same Jenkins' box which obligates to use Windows as OS (third and last question).
Many thanks!
Lauther
The first approach is to install Jenkins on Linux, however, I have been reading and Jenkins basically what it does is to call the Redgate SQL Change Automation cmdlets via powershell. As far I know, the cmdlets can be installed on Windows only (first question here), being in this way, can Jenkins call the cmdlets installed in a remote machine (second question, no make much sense to me, but you never know) or the cmdlets must be installed in the same Jenkins' box which obligates to use Windows as OS (third and last question).
Many thanks!
Lauther
Tagged:
Best Answer
-
David Atkinson
Posts: 1,462 Rose Gold 2
The cmdlets can't currently be run on Linux so your best bet if you have Jenkins on a Linux Master is to have a Windows Slave which will be used to run the cmdlets. The cmdlets are installed on the Slave machines, not the Master (Jenkins server).
Also, it's worth bearing in mind that you don't have to physically install the PowerShell on the Slave. Instead, your script can install SQL Change Automation from the PowerShell Gallery.David Atkinson
Product Manager
Redgate Software
