Export database with tables issue. Not keeping auto increment
<p>I'm using SSMS to export some tables from a database on one server to a different database on a different server.</p>

<p>I'm using the SQL Server Import and Export Wizard to Export from the old one to the new one.
It works great but it does not keep the auto increment.</p>

<p>Is there a way to export with it keeping the auto increment <strong>or is there a simple SQL code to tell all tables in the new database that the column "id" should be the primary key &amp; auto inc?</strong></p>

<p>I can't export SQL scripts since they'll become too big.</p>

<p>Thank you.</p>