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.

My main question, is that is it possible to have an instance of MSSQL 2012 and 2008 on the same machine?

The reason for this question, is that I need to restore some databases (currently in version 539) and re-export them, so they are in a acceptible format for my main MSSQL 2012 instance?

Would this cause complications anywhere on the line? or would it be alright for this to take place?

share|improve this question
    
I wouldn't recommend migrating from one version to another. Depending on your code, multiple problems will arise. –  schaiba Jan 29 '13 at 18:55
    
At a previous job, I had 2000, 2005, and 2008 r2 all on one machine without problems, altough some people had issues when initially installing multiple versions. It should work, based on a history of it working. –  thursdaysgeek Jan 29 '13 at 19:14
add comment

1 Answer

up vote 1 down vote accepted

You can run multiple versions of SQL on your machine, it will just need separate instance names.

share|improve this answer
    
I'd be very careful when installing SQL 2008 after SQL 2012 is already installed, especially if the 2012 is already a production instance. If you do go down that path, make sure you have solid backups of your server (and not just your databases) before you start. (If it were me, I'd find another machine/VM/something, and install 2008 there.) If you are installing SQL2008 first, then SQL2012, then forget I mentioned it. –  darin strait Jan 29 '13 at 21:32
add comment

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.