January 31, 2011 at 9:21 pm
Dear Friends, Do you have checklist for pre migration from SQL Server 2005 to SQL Server 2008 ?
February 1, 2011 at 12:27 pm
Not sure what you mean by a "checklist" or even "pre-migration".
In my experience there really isn't all that much to worry about in terms of migrating databases from 2005 to 2008.
It depends upon how you plan to do it: in-place upgrade or migrate to a new instance on the same or different server. In the later case just make sure to transfer your logins, service master key and certificates as needed. Make sure you re-initialize you backup and recovery mechanism to the standby server.
You will have to be more specific about how and what you are doing before I could give you any more specific information.
The probability of survival is inversely proportional to the angle of arrival.
February 2, 2011 at 11:04 am
sqlnaive (1/31/2011)
Dear Friends, Do you have checklist for pre migration from SQL Server 2005 to SQL Server 2008 ?
I recommend using Microsoft's SQL 2008 Upgrade Advisor, available here.
I agree with struner - more info about your plans is needed. Are you doing an in-place upgrade or building a new server and moving the databases over? In either case, first make backups in sql 2005 and stash those away someplace. Once you load those databases in 2008, they cannot be restored to 2005, so if you need to fall back to 2005 for some reason, you'll need those backups.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply