MS SQL Server - Primary key and identity fields information got lost by "Import Da

Author

Primary key and identity fields information got lost by "Import Da

ulrich schumacher

2006-03-15, 7:29 am

Hi all!

I want to import data from Sql Server 2000 into Sql Server 2005.
When i select "Import Data" in 2005 and import tables directly from the 2000
Data Source, the primary keys and the identity fields information is lost in
2005.

Who knows why?

Best regards
Ulrich Schumacher

Uri Dimant

2006-03-15, 7:29 am

urlich
How about BACKUP /RESTORE commands
Or you can create a linked server to SQL Server 2000 and run SELECT * INTO
Schema.Mytable FROM SQL2K.Database.DBO.Table it ON SQL Server 2005

"ulrich schumacher" < ulrichschumacher@dis
cussions.microsoft.com> wrote in
message news:D20F7B7B-5C85-441B-AFE5- 14191B3DF6CA@microso
ft.com...
> Hi all!
>
> I want to import data from Sql Server 2000 into Sql Server 2005.
> When i select "Import Data" in 2005 and import tables directly from the
> 2000
> Data Source, the primary keys and the identity fields information is lost
> in
> 2005.
>
> Who knows why?
>
> Best regards
> Ulrich Schumacher
>
>

Sponsored Links