Error after migration: Cannot insert the value NULL... dbo.log

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
7 years ago
Hello, after doing an Azure migration to Everleap, when restoring the database on the new server when we enter the new url an error message appears:

Cannot insert the value NULL into column 'Id', table 'xxxxxxxxx.dbo.Log'; column does not allow nulls. INSERT fails.
The statement has been terminated.


The setting.txt file is configured with the new database, we have also manually replaced in the new database some references to the old url that we have found in dbo.setting and in dbo.store, we have also purged dbo.log. It has not been useful, the error continues. Any idea?

Thanks in advance.

Regards.
7 years ago
Solved.

If it is useful for someone, as Azure doesn´t let make .bak copys, just .bacpac, I copied the original database to a local Sql Server and exported as .bak, but the table keys were lost.
Best solution is export to .bacpac from azure, import as "Import Data-tier application", and then export as .bak, this is a perfect copy.

Regards.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.