Activity overview
Latest activity by Russell
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.
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...
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...
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...
Foreign Key nockeck in compare
I have a database where I will run a script to make FK be set to no check do some processing and then set them back to check. I think compare the database with my control database and I get all th...