Solved

sql 2005 -> 2008 in place vs fresh

Posted on 2011-03-17
2
257 Views
Last Modified: 2012-05-11
on a standard edition , is it better to uninstall 2005 and then reinstall 2008, compared to upgrade?

thanks
0
Comment
Question by:anushahanna
2 Comments
 
LVL 5

Accepted Solution

by:
boowhup earned 500 total points
ID: 35160938
We've been doing in place migration of our dev/test/production 2005 servers to 2008 without an issue. If you don't  have dev/test environments leave the databases in 90 compatibility mode initially, and test them one by one if you want to move them to 100 compatibility (or you could just leave them at 90 indefinitely).
0
 
LVL 6

Author Comment

by:anushahanna
ID: 35169803
thanks for your input..
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Alter a column in sql 34 31
Sql Server group by 10 44
average of calculation (TSQL) 4 26
Check ALL SP in database make sure there are no errors 17 43
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

828 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