Drop columns

jagadeesh_m1229

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

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

jagadeesh_m1229

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

David Atkinson

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

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

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

Thank You David Atkinson