ExternalId Required should not be constraint NOT NULL

  • 12Views
  • Last Post 3 weeks ago
William Bell posted this 4 weeks ago

We have a Salesforce table that is ExternalId Required, and using replication you are setting the SQL Server table at NOT NULL on this field. Unless we set it to be unique, I don't think this should be set to NOT NULL.


Can you please fix your side?


Order By: Standard | Newest | Votes
Mariia Zaharova posted this 4 weeks ago


Hello William,


As we have already mentioned, Skyvia creates a target database table according to the current source schema and if the field cannot be null in the source, the same constraint will be added to the target table. The Required attribute means that the field cannot contain nulls:




We have a feature request for adding options for target schema creation. We don't have any ETA, however, we will definitely inform you when it is implemented.


Best regards,



William Bell posted this 3 weeks ago

This is not true. If you create a table will nulls, and later add the field o change it, salesforce does not go back and fix it.