Running SQL script from GIT

[Xavier]

Hello all,

I try to configure a Task to run SQL scripts (located in git repository).

I try with Powershell / sqlcmd, but not sure this is possible / manageable ?

Starting my test with

Invoke-Sqlcmd -Username xxx -Password yyy -InputFile "gitrepo/folder/script.sql" -ServerInstance "YYYY"

failed and return:

Failing task since return code of [powershell -NonInteractive -ExecutionPolicy bypass -Command /bin/sh /opt/bamboo-agent-home/temp/xxx.ps1] was -1 while expected 0

Moreover, my needs would to execute only updated scripts.
Is there a way to do that ?

THanks in advance.

regards,

[Xavier · Accepted solution]

changing operating systems on plan task solved the issue