SQL script Deployment on All Environments
rjayakumar
Posts: 34
Hi,
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):
use dbname
go
insert into [dbo].[tablebname] values ('testExecution',Getdate())
go
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):
use dbname
go
insert into [dbo].[tablebname] values ('testExecution',Getdate())
go
________
Cheers,
Raghunandan
Cheers,
Raghunandan
Comments
I believe you've been in direct contact with my colleagues Emma and Mike to look at this issue in depth.
I understand that we weren't able to recreate an issue with Deployment Manager and that you've now solved the problem.
Best regards,
Chris
Redgate Software