I have been using SQL Server 2008 R2 for quite a while, and it is working great. Now I need to use SQL Server 2012. Will this effect my existing databases? How much risk is involved in installing SQL Server 2012 on a machine that has SQL Server 2008 R2 running?
Sql-server – install SQL Server 2012 on a machine with 2008 R2 already
installationsql serversql-server-2008-r2sql-server-2012
Related Question
- Sql-server – Couldn’t install SQL Server 2012 on machine with Windows 7 SP1, VS 2010 SP1
- Sql-server – How to skip reboot check and remove command line appearing during install of SQL Server
- Sql-server – Unattended SQL install on a remote machine
- SQL Server Upgrade – Moving from SQL Server 2008 to 2012
- SSRS – Impact of SQL Server Migration from 2008 to 2012
- SQL Server 2012 – Can It Be Installed on Same Machine with SQL Server 2005?
- Sql-server – How to resolve “the specified account already exists” error during SQL Server 2008 R2 installation
Best Answer
You can simply install a new, named instance, and the two instances can live side-by-side with no risk - just be sure that your connections strings etc. are clear and correct (many problems arise from connecting to
LOCALHOSTwhen you meant to connect toLOCALHOST\OtherInstance).Depending on resources you may want to be sure to cap both servers using the max server memory configuration option, or perhaps even only running one instance at a time. I assume this is on your local development environment.
I'd suggest abandoning the 2008 R2 version of the client tools and using the 2012 version consistently. It has much better functionality and can manage both versions seamlessly.