Moving Sql2000 databases to 2005 one by one

Sorry for cross-posting!

We need to migrate our SQLserver2K one by one to a new server with
SQLserver2005.

I plan to create an empty database in 05' with the same name of that of 2K,
create a backup for 2K database and then restore it in 05. Will it work?
If not, what is the process to do this correctly and safely?

Thanks a million.

Bill

Use SQL Server Upgrade Advisor before migarting.
You can backup/restore or detach/attach databases.

Change compatibility level to 90 after migrating databse on SQL Server
2005


Regards
Amish Shah

Bill,

You should be able to either take a backup under 2000 and then just restore
this backup to 2005 or detach from 2000 and attach the original MDF/LDF or a
copied version to 2005.

Use the Upgrade Advisor to see that the code works under 2005 (90 compat)
first.

Chris Wood

"Bill nguyen" < billn_nospam_please@
jaco.com> wrote in message
news:%235al72zUGHA.5108@TK2MSFTNGP09.phx.gbl...
> Sorry for cross-posting!
>
> We need to migrate our SQLserver2K one by one to a new server with
> SQLserver2005.
>
> I plan to create an empty database in 05' with the same name of that of
> 2K, create a backup for 2K database and then restore it in 05. Will it
> work?
> If not, what is the process to do this correctly and safely?
>
> Thanks a million.
>
> Bill
>
>

Which server I should install Upgrade Advisor? The new one (running 05) or
the old one (running 2000)?

I just did a backup/restore withour running Upgrade advisor. All tables and
views look ok, but I got error trying to ope Database diagram because "the
database doesn't have a valid owner!"
Where do I need to go to change the compatibility level?

Thanks

BN
"amish" <shahamishm@gmail.com> wrote in message
news:1143649568.136416.302840@g10g2000cwb.googlegroups.com...
> Use SQL Server Upgrade Advisor before migarting.
> You can backup/restore or detach/attach databases.
>
> Change compatibility level to 90 after migrating databse on SQL Server
> 2005
>
>
> Regards
> Amish Shah
>