Posted by Mork69 on 02/13/07 09:33

On Feb 12, 5:52 am, tootsu...@gmail.com wrote:
> Help. I have been tasked with upgrading a 2000 instance to 2005.
>
> I have actually done this before, but it was a long time ago, and I
> didn't do it alone. Now, the sitation is little different, and I need
> to know the EXACT steps to take.
>
> Does anyone have a FAQ or link that outlines migration steps? I found
> one on sql server central, but it isn't very detailed.
>
> One of the important things I need to know is, how do I create a
> rollback plan if I am upgrading from 2000 to 2005 on the same server
> (instance)?
>
> Also, why can't I seem to find a comprehensive list of TO DO's when
> upgrading? Doesn't microsoft provide this? You would think so. I will
> run upgrade advisor first, but isn't there also documentation
> somewhere?
>
> I seem to recall lots of permissions issues that arose with 2005.
>
> HELP
>
> Thanks

The only reliable way to catch all issues is to script out your SQL
2000 databases and then rebuild them on a SQL 2005 database with
compatibility level 90. This method is much better than using the
Upgrade Advisor alone.

For tools that make this process easy please visit www.dbghost.com

Regards,

Malcolm

[Back to original message]