Missing tables to compare
Daniel Handley
Posts: 214
Hi
I need to check a few things with you before I can answer your question.
In SQL Compare, do you have these two options checked:
Ignore constraints and index names
Treat items as case sensitive
Having "Ignore constraints and index names" checked, within SQL Compare, will ignore differences that are found in the syindex table with regard to the primary keys and their naming conventions.
It is good practise to have this unchecked - off.
If "Treat items as case sensitive" is checked then objects that are named the same but their differences in case will be ignored.
Generally for comparing a table have this checked - on.
However if you have either of these checked it may explain why you are seeing the different results between Data Compare and SQL Compare.
In addition you mention that the owners are different between the databases. This will make each a different object and thus SQL Data Compare will view them missing.
I hope this gives you some avenues to explore.
Please get back to me and let me know how you get on. If you still have problems we can take a further look.
Regards
Dan
I need to check a few things with you before I can answer your question.
In SQL Compare, do you have these two options checked:
Ignore constraints and index names
Treat items as case sensitive
Having "Ignore constraints and index names" checked, within SQL Compare, will ignore differences that are found in the syindex table with regard to the primary keys and their naming conventions.
It is good practise to have this unchecked - off.
If "Treat items as case sensitive" is checked then objects that are named the same but their differences in case will be ignored.
Generally for comparing a table have this checked - on.
However if you have either of these checked it may explain why you are seeing the different results between Data Compare and SQL Compare.
In addition you mention that the owners are different between the databases. This will make each a different object and thus SQL Data Compare will view them missing.
I hope this gives you some avenues to explore.
Please get back to me and let me know how you get on. If you still have problems we can take a further look.
Regards
Dan
Daniel Handley
Red Gate Software Ltd
Red Gate Software Ltd
This discussion has been closed.
