title: Data insert issue after migrating database from SQL Azure to SQL Server
body: <p>I have a database on SQL Azure which has an identity primary.
  After using SQL Server Import and Export Wizard, I transferred the data to my SQL Server 2008 R2 database.</p>
  
  <p>My ASP.NET Application runs fine and reads the data. But When I try to insert a value in a table 'User', it gives me an error:
  Cannot insert null in column 'UserId'.</p>
  
  <p>The reason being that it is not able to generate the identity value.</p>
  
  <p>How can I overcome this issue?</p>
  
  <p>PS: I tried Generating the scripts from SQL Azure, but the SQL file is 500MB in size and my host does not allow that big a script to run.</p>
  
  <p><strong>Edit</strong>: using Entity Framework for data access. The UserId field has an <code>IDENTITY property</code> (1,1).</p>
  
  <p><strong>Edit</strong> Tried to create the schema from SQLAzure Migration tool and then used the import/export data to copy the data.
  But the wizard does not maintain the relations amongst the rows.</p>