HandersonVA (ha*********@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,
es****@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx