Can't sync msde database

Brian DonahueBrian Donahue Posts: 6,590 New member
SQL Data Compare says a table can't be compared if the table or view doesn't have a suitable index. Without a unique column of data, SQL Data Compare can't match rows from the tables together.

You can fix this by using the mappings to specify your own custom row of data to use as a comparison key.

Regarding the error I can't really say. The gist of it is that the cast that's being applied to the data is incompatible with the underlying column definition. Is, by any chance, any of these objects in the SQL script that you'd posted a view? There are potential issues with doing updates through a view.
This discussion has been closed.