sql server (alternate): export to sql 2005 -- sql server (alternate)

export to sql 2005

HandersonVA
9/13/2006 7:36:43 AM

sql server (alternate): 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?

Re: export to sql 2005

Erland Sommarskog
9/13/2006 10:11:45 PM

HandersonVA (handersonva@hotmail.com) writes:
[quoted text, click to view]

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