November 24, 2009 at 7:45 am
I have SQL Server 2005 with SP3. Now i want to move ahead with migrating to SQL Server 2008. I am totally new to this and never migrated to any SQL Server versions. So if someone can please send me some step by step instructions that will migrate from SQL Server 2005 to SQL Server 2008.
and yes i also have only one SQL Server 2000 also so what would be the steps to migrate to SQL Server 2008.
Please let me know.
November 24, 2009 at 7:54 am
There are 2 basic options
1) In Place Upgrade - Using the existing database, it is upgraded to a new version directly and replaces the old version.
2) Side-by-Side Upgrade - The database is imported into a new version of SQL, usually on another server, leaving the old version intact.
Read up on those 2 options to get a basic understanding, then maybe you will have more specific questions that can be answered.
November 24, 2009 at 8:19 am
so is it right that the very first step is to run upgrade advisor and then move on to the second step?
November 24, 2009 at 8:49 am
Your first step is to read the UPGRADE section in Books online. That will give you the steps that occur, and what the documentation is. If you don't understand something, ask a question, but this isn't a simple 2 sentence thing someone can re-type for you. Check the Microsoft documentation first.
http://msdn.microsoft.com/en-us/library/bb677622.aspx
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply