HandersonVA (ha*********@hotmail.com) writes:
somehow i cannot migrate the database from ms sql 2000 to 2005, i
recreated the same database name and exported the data from 2000 to
2005. THen what happend was all the default values that i set on
tables are not transferred and stored procedures are not transferred.
how can i duplicate the same database in sql 2000 to sql2005 w/o
loosing anything?
The best is of course to keep all definitions of SQL Server objects
under version control, and build the database from the version control
system.
The simplest way to duplicate a database is to simply take a backup of
it and restore it on the target server.
You can also use the Copy Database Wizard, which gives you two choices:
attach/detach and the SMO method. The SMO method scripts everything, but
this method is unreliable. I have filed several bugs with it. You get to
the Copy Database Wizard by right-clicking the database in Object Explorer
and select Tasks->Copy Database.
--
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 
