title: How to enable Identity Insert for multiple tables at once?
body: <p>I'm using the SQL Server 2014 Import and Export Wizard to copy data from one SQL Server instance to another. </p>
  
  <p>I have 8 databases, each with 63 tables, so 504 tables in total.</p>
  
  <p>The Import/Export works just fine, data flows across into the destination database. The issue I have is that I need the <code>Enable Identity Insert</code> option for every table.</p>
  
  <p>I need <code>Enable Identity Insert</code> defaulted to ticked/selected, otherwise I'm going to be here all day just clicking <code>Edit mappings... &gt; Enable Identity Insert &gt; OK</code>... Move down... <code>Edit mappings... &gt; Enable Identity Insert &gt; OK</code>... Move down... <code>Edit mappings... &gt; Enable Identity Insert &gt; OK</code>...</p>
  
  <p>You get the idea...</p>
  
  <p>Is there any way to set the default for <code>Enable Identity Insert</code>..?</p>