Any issues with migrating 2005 to 2008

Posted on 2010-01-12
Medium Priority
Last Modified: 2012-05-08
When moving from SQL 2005 to 2008, is there any upgrade pains or potential roadblocks that one should be aware of. kindly advice. How easy of a migration is it, generally?

Question by:anushahanna
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 75

Accepted Solution

Aneesh Retnakaran earned 1000 total points
ID: 26299857
Hello anushahanna,

no, its straightforward



Assisted Solution

spikelly earned 1000 total points
ID: 26301544
Depending on your configuration (mirroring,replication,clustering,etc...) you can have some issues or the upgrade can also be straight forward. There are DEPRECATED and DISCONTINUED features that you should be aware of before upgrade or migrate to SQL Server 2008.
I would advise that you carefully read the Upgrade to SQL Server 2008 documentation from microsoft; then point out the changes that might apply to your environment.
Before upgrading to SQL Server 2008 RUN the Upgrade Advisor which will point out any issues (hardware, sofware prerequisite...) that might occur.
Here a re some documentation and helpful link:
1- How to: Upgrade to SQL Server 2008
2- Migrating to SQL Server 2008
3- Upgrade SQL Server 2005 to SQL Server 2008
4- Microsoft SQL Server 2008 Upgrade Advisor

Remember, Microsoft website is your accurate source for any kind of information regarding their products.


Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question