I would like to move from SQL Server 2008 R2 Express to SQL Server 2008 R2 Developer or Enterprise.
I just noticed that I have the following services running:
- SQL Server (MSSQLSERVER)
- SQL Server (SQLEXPRESS)
- SQL Server (SQLR1)
- SQL Server (SQLR1V2)
- SQL Server Agent (MSSQLSERVER)
- SQL Server Agent (SQLR1)
- SQL Server Agent (SQLR1V2)
What I would like to accomplish here is to maintain the databases I have in (local). How can I tell which instance this is running against?
Also, have the Express Edition completely removed and install either the Developer / Enterprise edition of SQL Server with the Management Studio interface. I ultimately want to have SQL Profiler at the end of the day.
I don't mind if I have to remove everything services, instances, management studios, etc.
As long as I can end up with 3 things:
- SQL Server Developer / Enterprise
- SQL Server Management Studio
- SQL Profiler
I have downloaded SQL Server 2008 R2 Developer (x86, x64, ia64) - DVD (English) from MSDN. However, according to the installation I already have Management Tools - Basic installed.
I actually created a new instance and I was given additional the 2 Management Tools options in the installation, as mentioned by mrdenny.