Saturday, February 25, 2012

migration from Beta 2 to Final edition

Will you please let me know how to have a smooth and NO DOWNTIME migration
from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final
version does not upgrade itself from Beta 2.
Thanks
John
I don't think there's any way to do a "smooth" migration. You cannot do an
in-place upgrade, so you'll have to do a side-by-side migration. I'm not
certain whether backed-up Beta 2 databases will restore on an RTM instance.
That's something you'll have to test on your end. Have you listened to any
of the migration webcasts? They discuss how to do side-by-side migrations
somewhat smoothly -- but no downtime might not be possible, depending on
your definition of that term.
Speaking of which, if you are running Beta 2 in production can we assume
that you're a TAP customer? Ask Microsoft for assistance.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"John" <netconsul@.gmail.com> wrote in message
news:OX$3NSc9FHA.1420@.TK2MSFTNGP09.phx.gbl...
> Will you please let me know how to have a smooth and NO DOWNTIME migration
> from Beta 2 to Final version of SQL 2005? As per Microsoft, SQL 2005 final
> version does not upgrade itself from Beta 2.
> Thanks
> John
>

No comments:

Post a Comment