asked on

SQL developer edition

I currently have SQL server 2014 enterprise installed on my SQL server, but I am going to install the sql 2014 developer edition.
Besides performing a backup on the databases, are there any issues I might encounter? Can I just install it over the existing installation?
It's running on windows server 2008 R2.

ASKER CERTIFIED SOLUTION

sameer2010

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Éric Moreau

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Dan

ASKER

Here's the versions that I'm running, the problem I have is that, my software asset management program is telling me I'm using the enterprise core version, but I don't think I am.
Is there away for me to identify that?

I looked up hte 12.0.2000.8 version and it's just saying it's SQL server 2014, it doesn't say enterprise or core, or anything like that. Where can i find that info?

Microsoft SQL Server Management Studio                                    12.0.2000.8
Microsoft Analysis Services Client Tools                                     12.0.2000.8
Microsoft Data Access Components (MDAC)                                    6.1.7601.17514
Microsoft MSXML                                     3.0 6.0
Microsoft Internet Explorer                                     9.10.9200.17377
Microsoft .NET Framework                                     4.0.30319.18063
Operating System                                     6.1.7601

Éric Moreau

you can execute:

SELECT @@VERSION

Open in new window

it will give you something like this:
Microsoft SQL Server 2014 - 12.0.4213.0 (X64)
      Jun 9 2015 12:06:16
      Copyright (c) Microsoft Corporation
      Developer Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )

Dan

ASKER

This is the result:

Microsoft SQL Server 2014 - 12.0.2000.8 (X64)
      Feb 20 2014 20:04:26
      Copyright (c) Microsoft Corporation
      Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

So it's the enterprise edition, based on how many cores I have?

Éric Moreau

Yes you have Enterprise edition.

Dan

ASKER

Thanks everyone for your assistance.