Solved

sql 2005 -> 2008 in place vs fresh

Posted on 2011-03-17
2
255 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sql Query Datatype 2 23
Rename SQL Instance/SQL Developer Edition 2012 2 18
This query failed in sql 2014 5 29
SSRS 2012 r2 - Parm Drop Down has Date/Time 12 30
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
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 …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

815 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now