Drop columns

jagadeesh_m1229 · May 22, 2018 6:05AM

Hi Team,

Hope you all good,

In our environment I have compared two databases source and target there is a comman table in both database but there is a difference in columns, source have 3 columns for example (A,B and C) target have 3 Columns has(A,B And D),while using Redgate compare from source to target Script generated as below

ALTER TABLE [dbo].[x] DROP COLUMN [D]

I need all columns in target table as it is. Could you please help on the same.

Thanks in advance.

David Atkinson · May 22, 2018 9:06AM

What's preventing you from adding column D to the source?

jagadeesh_m1229 · May 22, 2018 9:44AM

While Comparing with Redgate it was generating drop script also but we should not required that drop script.

David Atkinson · May 22, 2018 9:51AM

Yes, but if you have ABCD in the source and ABD in the target, it won't try to drop D. My question is why you can't add D to our source table.

jagadeesh_m1229 · May 22, 2018 10:42AM

It's not required in source.
How can i remove the column drop statement in our Sql compare while generating the scripts. is there any option

David Atkinson · May 22, 2018 11:41AM

There is sadly no way to ignore columns in the tool, so other than editing the script, or adding the column in the source, I don't have a good answer for you.

jagadeesh_m1229 · May 22, 2018 12:48PM

Thank You David Atkinson

Drop columns

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk