I solved my issue but putting this here just in case someone else has the same issue.
I was updating a database that hasn’t changed in a few months (maybe a year) and it gave the error:
“The target database schema could not be retrieved. The reverse engineering operation cannot continue
because you do not have View Any Definition permission on the server ‘mssql5.gear.host’.”
Looking at the database page on https://my.gearhost.com, it looks like the server name changed to ‘den1.mssql5.gear.host’.
Updating my connection string to include den1 seems to have fixed the issue. Not sure when den1 was added. Guessing a missed an email about this at some point.