When you use Import data its not guaranted that the schema fully transfered. I have faced this problem with default values. I used the RedGate SQLCompare which resolved the problem. If you dont have redgate then first create schema and run on target server and then use import data.
Cannot insert the value NULL into column 'id'
I got error while creating and publishing Content, after moving umbraco site from Localhost to server.
-----> I used "Tasks ->Import Data" using Sql Server 2008 to transfer umbraco database. I also checked in "Enable Identity Insert"
--------> I tried to save and create templates and Document types. It works.
-------> there is no problem to perform "Republish Entire site" .
Problem is I can't create Content and I can't publish Content.
How can i solve this problem?
thanks
/Jivan
Umbraco 4.7.1
Hi. It seems that the identity option of the "id" column is somehow turned to be off for the database table mentioned after importing data.
When you use Import data its not guaranted that the schema fully transfered. I have faced this problem with default values. I used the RedGate SQLCompare which resolved the problem. If you dont have redgate then first create schema and run on target server and then use import data.
is working on a reply...