Importing tables - identity columns lost

[amberlynn]

Hello,
When I import tables from one SQL Server database to another, all my Primary Key fields that are set to Identity columns, are no longer set to Identity columns.
I have to go in manually to every table and reset this.
Is there a way around this??
Thanks!
Amber

 

[bborissov]

How you importing data?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[ptheriault]

If you are using the wizard it will drop your identity column,

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[amberlynn]

I am using the wizard.
Is there a better way to do it?

 

[RiverGuy]

If the tables are new tables in the target database, then generate an sql script for the source for desired tables, run it on the target database, then import the tables with identity insert on.