"Paul" <nospam@mydomain.com> wrote in message
news:%23yrCVthbGHA.4900@TK2MSFTNGP02.phx.gbl...
>I downloaded the trial version of SQL Server 2005 to facilitate the
>migration of a web site database from a SQL2000 server to the new host's
>2005 SQL Server.
>
> It transferred the data itself OK, but I found two major problems with the
> structure:
>
> 1. All my Views were created as Tables instead of Views in the new server.
> 2. It dropped all the primary keys from my tables.
>
> Any idea why this happened, and how to repair this? Especially the dropped
> PKs. I don't like the idea of manually going through all 50+ tables to set
> the PK column.
>
> Thanks for your help.
>
> Paul
>

"Michael Hotek" <mike@solidqualitylearning.com> wrote in message
news:%23X0pjMnbGHA.2456@TK2MSFTNGP04.phx.gbl...
> It would help to know how to do this "data transfer" because I have never
> seen that type of behavior.
>
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.

"Paul" <nospam@mydomain.com> wrote in message
news:eKXnzUvbGHA.4108@TK2MSFTNGP03.phx.gbl...
>I right-clicked on the destination database, selected Tasks>Import Data
>
> On reconsidering my steps, maybe that did exactly what it is titled -
> imported data only. Perhaps the proper thing would have been to create a
> complete backup on the original and do a restore to the new?
>
> Paul
>
> "Michael Hotek" <mike@solidqualitylearning.com> wrote in message
> news:%23X0pjMnbGHA.2456@TK2MSFTNGP04.phx.gbl...
>> It would help to know how to do this "data transfer" because I have never
>> seen that type of behavior.
>>
>> --
>> Mike
>> http://www.solidqualitylearning.com
>> Disclaimer: This communication is an original work and represents my sole
>> views on the subject. It does not represent the views of any other
>> person or entity either by inference or direct reference.
>
>