We have 3 different environments and when DM is chosen to deploy the script - the deployment happens on all 3 servers.
What might have gone wrong?
The deploy.ps1 code is as below.
sqlcmd.exe -S $databaseServer -U $databaseUserName -P $databasePassword -i query.sql -d $databaseName | Out-Default
The SQL Script being executed is as below (query.sql):
insert into [dbo].[tablebname] values ('testExecution',Getdate())