SQL script Deployment on All Environments

Automated deployment for web applications and databases

Moderators: Mike Upton, justin.caldicott, Sean.newham, csmith, chirayu, DavidSimner, david.conlin

SQL script Deployment on All Environments

Postby rjayakumar » Mon Sep 16, 2013 11:45 am

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
rjayakumar
 
Posts: 25
Joined: Wed Aug 21, 2013 7:49 am
Location: Bangalore

Postby csmith » Tue Sep 17, 2013 5:05 pm

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
Chris Smith
Project Manager
Deployment Manager
csmith
 
Posts: 117
Joined: Thu Jun 30, 2011 2:15 pm
Location: Cambridge


Return to Deployment Manager

Who is online

Users browsing this forum: No registered users and 0 guests