Posted by Erland Sommarskog on 09/13/06 22:11

HandersonVA (handersonva@hotmail.com) writes:
> when i export data on sql 2000 to sql 2005, i lost all the primary key
> setting and relationship.
> how can preserve what database structure on the sql 2000 when i move to
> sql 2005?

The safest way is simply to backup the database and restore it on SQL2005.

Next best way is to build a database from the scripts you have under
version control.

Else, well, you can script, and then move data. More chances for things
to go wrong. The Copy Database Wizard in Management Studio packages this,
but unfortunately it's buggy.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SQL Between Dates
• Prev in forum: Re: stored proc bug with datetime variable
• Thread view: Re: export to sql 2005

[Reply to this message]