Hello:

If you have a fresh install of SQL 2005 and you want to use the Copy
Database Wizard to upgrade the SQL 2000 databases to SQL 2005, does the Copy
Database Wizard create your SQL 2000 databases in the new SQL 2005
environment?  Or, do you have to have already created the databases in SQL
2005 before copying?

I guess I just want to know if using this wizard does truly bring your SQL
2000 databases into the new SQL 2005 Management Studio as SQL 2005 databases
or if you have to have created the databases over in 2005 beforehand?  Does
the wizard actually "migrate" the old databases over or is it just "copying"?

Thanks!

childofthe1980s

Hi

As Tom has said you can have two instances of SQL Server running on the same
machine and the second instance can be SQL 2005. SQL 2000 databases can be
attached or restored to the SQL 2005 instance and there is no need to use the
copy database wizard.

You should run the SQL 2005 upgrade advisor on your SQL 2000 databases
(before you install SQL 2005), this will highlight any incompatibilities
between the two versions. Once restore onto your SQL 2005 instance and all
the incompatibilities have been changed, you can then change the database
compatibility mode to SQL 2005 and fully utilise the features available in
SQL 2005.

I would strongly advise storing your database objects in a version control
system so you can track any changes that you may make.

John

Show quoteHide quote

SAN Replication for DR site
SQLServer 2000 isql error
How to output table as XML with elements on separate lines and indented?
Changing NULL, to NOT NULL
Prune Data from DB (Code Review)
log shipping problem
SQL 2005 Cluster
Load Testing and Performance
Documenting DB with Visio
SQL Server 2005 Error