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

WITH ENCRYPTION not being ignored when comparing

I am comparing two databases which are identical except for WITH ENCRYPTION on some object. I have comments ignored and have set it to insert WITH ENCRYPTION, but it is showing the databases as different.

I want it to compare two databases without worrying about WITH ENCRYPTION being in there. I'm sure it did this in the old version...


compareproblemcs7.png
mcintyre321
0

Comments

3 comments

Sort by
  • Brian Donahue
    Hello,

    I don't believe that the options in SQL Compare have changed in this regard since the previous version. You just cannot ignore the fact that one object is encrypted, but the other is not. You do have the opportunity to specify an option to add WITH ENCRYPTION if you are going to migrate a function that is not encrypted and would like it to be created WITH ENCRYPTION.
    Brian Donahue
    0
  • mcintyre321
    any chance it could be added as a feature then? :)
    mcintyre321
    0
  • JonathanWatts
    Hi mcintyre321,

    I think I have been able to reproduce your issue here, it appears there something strange happening with the ADD WITH ENCRYPTION option.

    This might sound a bit strange but can I ask you what the result of comparing the databases the other way around? So that CGixLatest is on the left and CGiX6517 is on the right?

    Regards,

    Jonathan
    JonathanWatts
    0

Add comment

Please sign in to leave a comment.