|
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
Navigation:
[Reply to this message]
|