Schema update for Azure: column name does not exist

Question

I have two databases: one on the local database and the same, but published on Azure.

For the local database, I made several changes: one, many relationships were added . Models are Device and DigitalSystem

 public class Device { [Key] public int DeviceID { get; set; } //FK public int DigitalSystemID { get; set; } [ForeignKey("DigitalSystemID")] public DigitalSystem DigitalSystems { get; set; } } public class DigitalSystem { [Key] public int DigitalSystemID { get; set; } public virtual ICollection<Device> Devices { get; set; } } 

In this case, the table inside the local database is updated and includes the DigitalSystemID field.

However, when I create a script and try to deploy the circuit, this error appears:

Error message:

Question:

I do not understand this error, since I believe that this column is declared. Can someone help me figure this out? How can I deploy this schema update to my Azure database?

Thanks in advance.

Update:

This is the structure of the Device table in Azure.

It does not have a DigitalSystemID column, but that is what I am trying to achieve by synchronizing Azure to look like localDB. Is this not done by updating the circuit?

This is the result of the Data Migration Assistant when I try to deploy the schema [Pay attention to 5 errors (I described one of them here)]:

Comparing the schema with Visual Studio:

I tried to compare the circuits to detect the differences. However, the comparison result shows that there are no differences , which does not make sense:

No differences found.

Answer 1

Azure PaaS SQL DB has a certain limitation Use the Sql Migration Wizard to move tables with a schema. This tool will notify you if there are compatibility issues.