title: Import DATA from an SQL server database with identities column
body: <p>I would like to export all the data from a database to a new one with SQL Server Manager studio.</p>
  <p>I used import and export assistant (taks -&gt; export data) but after the import when I try to save new data</p>
  <p>I have insertion error due to identity column error when I try to insert data:</p>
  <blockquote>
  <p>com.microsoft.sqlserver.jdbc.SQLServerException: Unable to insert null value in column 'id'</p>
  </blockquote>
  <p>Although I specified to keep identity insert before the export.</p>
  <p>I would like to export data in a new database with all the Identities column constraints.</p>