How can we help you today? How can we help you today?

Drop columns

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.
Jagadeesh
0

Comments

6 comments

Sort by
  • David Atkinson
    What's preventing you from adding column D to the source?
    David Atkinson
    0
  • jagadeesh_m1229
    While Comparing with Redgate it was generating drop script also but we should not required that drop script.
    jagadeesh_m1229
    0
  • 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.
    David Atkinson
    0
  • 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
    jagadeesh_m1229
    0
  • 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.
    David Atkinson
    0
  • jagadeesh_m1229
    Thank You David Atkinson
    jagadeesh_m1229
    0

Add comment

Please sign in to leave a comment.