Red Gate forums :: View topic - SQL script Deployment on All Environments
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Deployment Manager
Deployment Manager forum

SQL script Deployment on All Environments

Search in Deployment Manager forum
Post new topic   Reply to topic
Jump to:  
Author Message
rjayakumar



Joined: 21 Aug 2013
Posts: 8
Location: Bangalore

PostPosted: Mon Sep 16, 2013 11:45 am    Post subject: SQL script Deployment on All Environments Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
csmith



Joined: 30 Jun 2011
Posts: 117
Location: Cambridge

PostPosted: Tue Sep 17, 2013 5:05 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group