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

microsoft.public.sqlserver.server

15 Mar 2006 10:21 AM

ulrich schumacher

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

15 Mar 2006 12:01 PM

Uri Dimant

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

Show quoteHide quote

"ulrich schumacher" <ulrichschumac***@discussions.microsoft.com> wrote in
message news:D20F7B7B-5C85-441B-AFE5-14191B3DF6CA@microsoft.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
>
>