Geek Answers Handbook

Why are all the tables missing in comparing the data in visual studio 2010?

I am trying to use the data comparison feature in visual studio 2010 to find out what is different between two tables in two different databases. Both databases are local, and I can see them and retrieve data from the tables I'm looking for. However, in the data comparison wizard, I do not see the list of tables as I should be, according to MSDN . The constructive part of the comparison works fine. Any ideas that I can skip compared to what seems straightforward?

+5
source share
1 answer

Found the answer. One of the notes in the link, I said that the schemes must match, and there must be a unique or primary key or index. After adding the primary key, it still does not work. Finally I realized that it matters in the definition of data. One database had a camel case, and the other was uppercase. Changing the upper case for the camel made it work.

I did not understand that this question matters for MSSQL, especially since the structure comparison worked.

Optional: Names must match. I did not understand that this is the plural, and the other is the only one due to EF. Verify that the names are identical.

+5
source

More articles:


All Articles