I am attempting to move a database from sql server 2000 to sql server 2008(not R2) using the database copy feature in offline mode. After copy is complete a database comparison tool shows that the table definition for some of the tables is missing the IDENTITY(1,1) attribute.

The original table looks like this on 2000.

[SourceID] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL ,
[VisitID] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
[AbstractID] [varchar] (44) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL ,
[EventSeqID] [int] NOT NULL ,
[TextSeqID] [int] NOT NULL ,
[TextID] [numeric] IDENTITY(1,1) NOT NULL ,
[TextLine] [varchar] (138) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
[TextTimeStamp] [timestamp] NULL ,
[RowUpdateDateTime] [datetime] NULL

After copy the table looks like this on 2008:

[SourceID] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL ,
[VisitID] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
[AbstractID] [varchar] (44) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL ,
[EventSeqID] [int] NOT NULL ,
[TextSeqID] [int] NOT NULL ,
[TextID] [numeric] NOT NULL ,
[TextLine] [varchar] (138) COLLATE SQL_Latin1_General_CP1_CS_AS NULL ,
[TextTimeStamp] [timestamp] NULL ,
[RowUpdateDateTime] [datetime] NULL



Any ideas why?