If I have a SQL Server 2005 database, and want to upgrade it to run on 2008, what is the best approach, and what problems am I likely to encounter?
asked
Upgrading to SQL Server 2008 from SQL Server 2005
I'd upvote except I've used up all my vote3s for this voting period!
The first thing you should do is download and run the Microsoft SQL Server 2008 Upgrade Advisor. Microsoft SQL Server 2008 Upgrade Advisor analyzes instances of SQL Server 2000 and SQL Server 2005 to help you prepare for upgrades to SQL Server 2008:
Upgrade Advisor does not change any configuration settings or data.
Upgrade Advisor can analyze remote instances of SQL Server, except for SQL Server Reporting Services. To analyze Reporting Services, Upgrade Advisor must be installed and executed on the report server.
Upgrade Advisor provides the UpgradeAdvisorWizardCmd command-prompt utility to help you more easily scan multiple instances of SQL Server. See the Upgrade Advisor documentation for additional information.
Uninstalling Upgrade Advisor requires the .NET Framework 2.0. Uninstall Upgrade Advisor before uninstalling the .NET Framework 2.0.
SQL Server 2008 Books Online: Using Upgrade Advisor to Prepare for Upgrades
Problems you might encounter:
Besides following the good advice provided by Mitch Wheat, when I upgrade between versions of SQL Server, I prefer to upgrade hardware at the same time. This way, I can install the new hardware, the new OS, and the new SQL Server version, and verify they are all working. Then, I perform a trial migration of the databases onto the new hardware and software, and then I can test the migration without affecting my existing installation. Once I am convinced the test migration was successful, I then make the actual cut over during an appropriate maintenance period. If there should be any problems with the cut over, I can always revert back to the older installation. When upgrading, I always prefer to have a back out plan ready, just in case.
This sounds like I have come to the right place for help...Preparing the process of moving to sql server 2008 from 2005 focusing focusing on consolidating all of the SQL servers that are out there on a core machine and have the different databases running on it. Is there a step by step guide; this is my first time doing an upgrade of sql server
Search this site for "upgrade". Here is the first question that caught my eye that had some form of a checklist (and a good one, at that):
http://ask.sqlservercentral.com/questions/21142/upgrading-sql-2000-to-sql-2008
This sounds like I have come to the right place for help...Preparing the process of moving to sql server 2008 from 2005 focusing focusing on consolidating all of the SQL servers that are out there on a core machine and have the different databases running on it. Is there a step by step guide; this is my first time doing an upgrade of sql server
