Comments
Sort by recent activity
No, I am scripting out the constraint change from check to nocheck. The thing is the constraint is fine. It now checks just SQL Compare shows that it should not. / comments
No, I am scripting out the constraint change from check to nocheck. The thing is the constraint is fine. It now checks just SQL Compare shows that it should not.
I am checking there and I am generating the Foreign Key from Query Anaylzer and it does not generate with nocheck in the syntax as I would expect it to .
Also I have tested the Foreign Key be inserting data that is not valid and it FK constraint blocks my insert. / comments
I am checking there and I am generating the Foreign Key from Query Anaylzer and it does not generate with nocheck in the syntax as I would expect it to .
Also I have tested the Foreign Key be inser...
Not quite. My issue is that I have the same constraint in two database, in both it is as I built it (set to check) When I compare it comes up identical.
In one database I alter the contraint and make it nocheck. Compare now and they are different because of the nocheck.
In the same database I alter the constraint again making it check. Compare again and I would expect them to be identical, but they are not. They still show up as being different by the nocheck flag on the constraint. But if I generate the constraint it doesn't generate the nocheck flag and the constraint works if I try to edit in bad data.. / comments
Not quite. My issue is that I have the same constraint in two database, in both it is as I built it (set to check) When I compare it comes up identical.
In one database I alter the contraint and...
That would allow me to ignore it but thats not really what I want. I was wonding why MSSQL thinks the FK is set to check and it does but SQL Compare doesn't. THe only way I can get SQL Compare to see the FK as checking is to drop and rebuild the FK.
I don't want to do that every time a need to do this.
I am using the comparing option to filter them out. I guess I would rather beable to check for it. I was wondering if there was some other MSSQL setting I could set to handle this. / comments
That would allow me to ignore it but thats not really what I want. I was wonding why MSSQL thinks the FK is set to check and it does but SQL Compare doesn't. THe only way I can get SQL Compare to...