SQL script Deployment on All Environments

rjayakumarrjayakumar Posts: 34
edited September 17, 2013 12:05PM in Deployment Manager
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
________
Cheers,
Raghunandan

Comments

  • csmithcsmith Posts: 138 Bronze 1
    Hi

    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
    Divisional Development Lead
    Redgate Software
Sign In or Register to comment.