Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

If we wanted to move SQL 2008 from a 2003 OS to a virtual 2012 OS (using VM Ware), does anyone know if there are any licensing or technical problems that would get in the way?

All the instructions I've seen on moving SQL server from one machine to another assume the new machine has the same OS. I realize that there are licences have more cores and fail over capability, but for now we are fine with a simple installation.

share|improve this question

1 Answer 1

up vote 4 down vote accepted

If you're moving from the same version of SQL Server across different versions on Windows Server, you should be fine. Just dump the databases and restore them on the new box, migrate/recreate user permissions, and you're done.

share|improve this answer
    
Thanks, I wasn't expecting it to be that simple. –  David Nov 19 '12 at 16:41
    
@David SQL Server doesn't care what OS it's on as long as it's supported by Microsoft. SQL Server 2008 doesn't really behave any differently based on which Windows OS it's running on top of. –  MDMarra Nov 19 '12 at 16:45
    
That's great, thanks again! –  David Nov 19 '12 at 16:46

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.