The references are also still there in Thinkwise
 

So… how do i “force” to recreate the constraints?

Hi Dennis,

We tried to do a full upgrade again hoping that the constrains would return but they keep missing. How do we get the constraints back?

Backup restore would be the easiest, or you could opt to do a Full upgrade instead. This will reapply all logic, keys, indexes and constraints.

DF constraints are default values, C are Check constraints. 

how do i “force” to recreate the constraints?

Same as stated above. References are keys in SQL Server, not constraints.

Recommended is to backup your end product before upgrading it. In case of any error, you can easily revert back by restoring the backup. 

Related idea: Upgrade rollback | Thinkwise Community (thinkwisesoftware.com)

Hi Mark,

A full upgrade is not fixing it unfortunately. I don't understand why it's not.

Greetings,
Dennis

Best thing to do now is going into SF > Data > Data migration and checking the "Rebuild table” checkbox. This will tell the SF to recreate the tables and migrate the data accordingly. That should also rebuild the Default value constraints. Once the affected tables have been checked, run a Creation to deploy it. This will of course take a while longer as all affected tables need to be recreated.

I ended up restoring a backup. Data migration didnt work unfortunately

That's unfortunate. I personally never encountered this scenario so I hoped this could solve it. Glad the restore fixed it