Database Sync after data type on field has been changed

You will got an error like this when doing Database Synchronization after changing the data type of the field on the table:

Solution:

• Drop the table and delete references from SQLDictionary

 1
 2
 3
 4
 5
 6
 7
 8
 9
10

DROP TABLE AXDB.dbo.NAMEOFTABLE

DELETE
FROM AXDB.dbo.SQLDICTIONARY
WHERE TABLEID IN (
 SELECT TABLEID
 FROM SQLDICTIONARY
 WHERE NAME = 'NAMEOFTABLE'
  AND FIELDID = 0
)

• Restart IIS
• In VS 2015, run DB sync again.

Thank you for reading.