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

Ignore insignificant differences in default values

Hi,
We have some tables where the only differences are similar to those shown below:

Database one:
[Hazardous] [bit] NOT NULL DEFAULT (0),
[Reefer] [bit] NOT NULL DEFAULT (0),

Database two:
[Hazardous] [bit] NOT NULL DEFAULT ((0)),
[Reefer] [bit] NOT NULL DEFAULT ((0)),

Is there any setting I can use that will cause these differences to be ignored?
kev1609
0

Comments

2 comments

Sort by
  • Michelle T
    The differences are ignored in the main comparison, they just show up on the side-by-side view.

    We have long-term plans to fix the side-by-side view on this issue, but so far worries about the performance impact have stopped us doing it.
    Michelle T
    0
  • DennisRehm
    I'm experiencing the same issue and found this post from two years ago. It is a nuisance to have tables show up as different, but not be different when synchronizing. We expect no differences between our development and test servers and any differences need to be reviewed.

    Any thoughts about implementing the enhancement, perhaps optionally? I am using SQL Compare 8.50.12.20.

    Thanks.
    DennisRehm
    0

Add comment

Please sign in to leave a comment.