I have just installed SQL Server 2008 R2 Developer edition (created a new instance for it:
DEVEDITION). I previously had and the default instance (
MSSQLSERVER) which was running SQL Server 2008 R2 Express.
I have ~20 DB's that are running on the default instance:
If this is possible, I would like to convert/upgrade the
MSSQLSERVER instance so that I can use all the bells and whistles of the Developer edition on it. i.e. Profiler, SQL Agent etc.
I have all DB's backed up and as it is a development environment I can uninstall all versions of SQL if needs be.
Thanks in advance.