title: sql server import export wizard - enable identity insert not working
body: <p>I am using sql server 2008.i have one ABC database on A server(source).now i want to copy all the schema and data of this database to my new database XYZ on B server(destination).for this i am using sql server import wizard.<br>
  now the scenario is:<br>
  In ABC database,many tables have identity columns as primary key.when i use import wizard, i set "Enable identity insert" to True(checked).
  but import process completes,i found that destination tables are created but primary keys are not set for tables and also identity is also not set.</p>
  
  <p>It just copies the data,not the Primary keys or identity fields.</p>
  
  <p>How to make it possible to work for "identity insertion" for all tables</p>
  
  <p>Pls help.thanks in advance.</p>