Activity overview
Latest activity by girish128
Hello @DanC, Thanks for the reply. I'm not completely aware about why but in general, we've been asked to use SQL server project when it comes to change the schema and other db model related stuff. Anything included in pre deployment and post deployment folder are mostly data scripts like modifying or adding new records to tables. With our current setup, even if I include any schema changes in pre or post, the scripts won't work. That includes, alter, create table and other DDML stuff. I'm not worried about enabling the constraint since I want to remove that column. In similar scenarios of this in past, our DBA generally manually modify the redgate generated script to move forward but I feel there must be better way.
Thanks, Girish / comments
Hello @DanC,Thanks for the reply. I'm not completely aware about why but in general, we've been asked to use SQL server project when it comes to change the schema and other db model related stuff.A...
SQL Deploy / Compare : The object 'CONTRAINT_NAME' is dependent on column 'COLUMN_NAME'
Hi,We're using Redgate Deploy for SQL Server deployment. The script generated with tool is somehow throwing following error:Altering [dbo].[Table1]
The object 'DF__Table1_I__SysSt__0333DC13' is dep...