Different methods to upgrade SQL Server 2005 to 2008
I have number of Oracle & SQL server 2005/2008 databases. I used to work with SQL server part time but seems I need to take care of them full time on our new upgrade project.
The latest work stack demands upgrading SQL server databases from 2005 to 2008. I have number of systems ranging from 10 GB to 200 GB and I am looking for a practical advice. I have done upgrade of some small dev 2005 databases by using detach/attach technique but not sure if I should try that on big database systems?
Is it also possible to upgrade the PROD systems with almost no downtime?
We use SQL server Analysis/Integration & reporting services. What do I need to do for them besides upgrading the software?
Can I run SQL server 2005/2008 on same box? I am thinking this because in case the upgarde fails I can go back to old 2005 version easily.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.