How can we help you today? How can we help you today?
minijebu
Activity overview Badges (0) Posts (1) Comments (3)

Comments

Sort by recent activity
Please correct me if i am not getting it right. In the 5th and 6th steps of using PRE/POST DEPLOYMENT SCRIPTS, 5. . Deploy this change to all environments, including prod and all dev workstations 6.   Re-link static data This means ,that i can re-link the table back to source control, only after making sure that, all DEV workstations(which is local to each developer) have done a PULL and applied the changes. So,if any DEV workstation fail to do so,and trying to do a PULL and APPLY CHANGES after i re-link the table ,then, it can fail. Kind Regards minijebu / comments
  1. Community
  2. SQL Source Control
  3. Adding new column to static data table
Please correct me if i am not getting it right.In the 5th and 6th steps of using PRE/POST DEPLOYMENT SCRIPTS,5. . Deploy this change to all environments, including prod and all dev workstations6.  ...
0 votes
Hi Alex, I have not thought about the option of moving the change to every workstation. I am trying to see if on each DEV work stations,we can do a PULL once and APPLY all the changes at once. Since we have so many DEV workstations , i find it difficult to apply the changes on each of them once i PUSHed each step in this process.I hope i understood you correctly on : 'AND TO EVERY DEV WORKSTATION' . And since we are in the moving phase of of automated deployment,currently the production is not yet part of it.We are working on it. Right now,the deployment is to a shared DEV environment only. So,i can actually rollback the changes i did and I will go for PRE/POST DEPLOYMENT SCRIPTS. Kind Regards minijebu / comments
  1. Community
  2. SQL Source Control
  3. Adding new column to static data table
Hi Alex,I have not thought about the option of moving the change to every workstation.I am trying to see if on each DEV work stations,we can do a PULL once and APPLY all the changes at once.Since w...
0 votes
Hi Alex, I tried the first method. Deployment went ok. But now,the issue is,when we do a  PULL and try to APPLY the changes on other developers' local instances,it fails. On the 'Get Latest' tab, we checked the differences in the versions on local instance and source control. The latest version on the source control included The structural change of the table(TableA),ie the new column(newColumnLevel) NOT NULLable is there. The static data changes,ie,The new values are there in the new column But once ,Apply changes is clicked,it failed The script is actually trying to create the table with the new column NOT NULLable and then it uses an INSERT statement which do not consider the new column at all. Something like this : CREATE TABLE [dbo].[RG_Recovery_1_TableA]<div>(</div><div>[id] [int] NOT NULL,</div><div>[description] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,</div><div>[cDate] [datetime] NOT NULL CONSTRAINT [DF_TableA_cDate] DEFAULT (getdate()),</div><div>[<b>newColumnLevel] [tinyint] NOT NULL</b><br></div><div>) ON [PRIMARY]</div><div>GO<br></div><div>IF @@ERROR <> 0 SET NOEXEC ON</div>GO<br> INSERT INTO [dbo].[RG_Recovery_1_TableA]([id], [description], [cDate]) SELECT [id], [description], [cDate] FROM [dbo].[TableA]--!!!!<i>the new column is not taken here and throws error</i>.<br><div>GO<br><div>IF @@ERROR <> 0 SET NOEXEC ON</div>GO</div> DROP TABLE [dbo].[TableA]GO<br><div>IF @@ERROR <> 0 SET NOEXEC ON</div>GO<br> EXEC sp_rename N'[dbo].[RG_Recovery_1_TableA]', N'TableA', N'OBJECT<br>GO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br>&nbsp;IF @@ERROR <> 0 SET NOEXEC ON<div>GO<br></div> Kind Regards minijebu / comments
  1. Community
  2. SQL Source Control
  3. Adding new column to static data table
Hi Alex,I tried the first method. Deployment went ok.But now,the issue is,when we do a  PULL and try to APPLY the changes on other developers' local instances,it fails.On the 'Get Latest' tab, we c...
0 votes
Total activity
5
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1