| Author |
Moving Sql2000 databases to 2005 one by one
|
|
| Bill nguyen 2006-03-29, 9:23 am |
| 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
| |
| amish 2006-03-29, 11:23 am |
| 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
| |
| Chris Wood 2006-03-29, 11:23 am |
| 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
>
>
| |
| Bill Nguyen 2006-03-30, 8:23 pm |
| 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
>
|
|
|
|