Hot answers tagged

18

Development edition licenses can be used to install anything that isn't production, provided that everyone that connects to the server has their own development license. MSDN licenses can be used as well if everyone has an MSDN license.


12

Short answer: yes. Slightly longer answer: yes as long as you have one developer license for every person accessing the development and staging servers. From the Licensing Quick Reference Guide: The SQL Server 2012 Developer Edition is a full-function version of the SQL Server software—with all the features and capabilities of the Enterprise ...


12

In general, yes. Once you have an application in production, every environment (dev, test, staging, production, etc.) needed to support that application needs to be licensed. As with all licensing advice, however, you need to get it in writing from Oracle Sales. Advice from some guy on the internet holds up about as well as you might expect if there is ...


10

A few things you'll want to watch out for: Changes to memory manager mean some changes to some dynamic management views - http://sqlblog.com/blogs/sqlos_team/archive/2011/01/04/sql-server-memory-manager-changes-in-denali.aspx fn_virtualfilestats no longer takes -1 for parameters - ...


9

Could you post a link to the forum you're citing, I'd like to read the full context of the post. I am not a lawyer, but legally speaking you don't need a license to use MySQL community edition. They do offer a paid-for enterprise edition. There are some additional tools you get, but I think the big thing people would use that for is support. I've talked to ...


8

http://www.oracle.com/technetwork/database/berkeleydb/downloads/licensing-098979.html Our open source license permits you to use Berkeley DB, Berkeley DB Java Edition or Berkeley DB XML at no charge under the condition that if you use the software in an application you redistribute, the complete source code for your application must be available and freely ...


8

Postgres (not Postgre) is absolutely free. You can do anything you want with it. For MySQL you will most probably need a commercial license if you plan to redistribute your application with a bundled database. Not sure if this is required if your application just needs MySQL but I think this also requires a commercial licenses because it is considered a ...


7

The Oracle Software Investment Guide says the following: Test/Staging - Test/staging environments are used to verify that new or customized code runs properly. This can be staged on separate servers or on the same servers used to run a development or production environment. Any Oracle software used in test/staging environment must be ...


5

First of all, the amount of information you've just provided isn't enough to clearly understand what exacly you mean by "using MySQL for one software product". Of course, you're free to use the MySQL Community Edition along with any proprietary, closed-source products you see fit. But as I understand, your company wants to integrate the database server into ...


5

In general, you can move named user licenses around so long as at any given point in time you can identify the 20 humans (or non-human licensed entities) that have access to the system. In your case, so long as there is never a point where all 40 users have access to the system, it sounds like you would be OK. Of course, as with any licensing question, you ...


5

Anybody can download and install oracle software without any installation codes being necessary. So in effect an Oracle licence is simply an entry in their Licence Management Services (LMS) database. Depending upon what you buy you will get a CSI number. In working with Oracle for more than 15 years this is all I have ever seen at customer sites: a piece of ...


5

Yes, that's fine: All software downloads are free, and most come with a Developer License that allows you to use full versions of the products at no charge while developing and prototyping your applications, or for strictly self-educational purposes. The full Developer License can also be found on OTN, including: Oracle grants You a nonexclusive, ...


4

It does not sound like your database and application would be very big in current terms. You could look into the freely available Microsoft tools for Visual Studio Express and SQL Server Express: https://www.visualstudio.com/en-us/products/visual-studio-express-vs.aspx ...


4

There is certainly an economical way to do this - get an MSDN subscription. The licenses that you get allow you to use the software specifically in development and test environments. It looks like currently $1,199 would cover your needs for SQL Server (and assuming you can make use of some of the other software too), but you could always invest more to get ...


4

We had a conference call with our Oracle Technology Sales Manager and an Oracle Solution Consultant. We discussed the Double-Take setup and they were able to confirm that based on the way we have our DR site setup and our primary site licensed, we do NOT need to license the DR site. This is of course assuming we do not deviate from the setup we discussed ...


4

I think the information by MySQL themselves are more reliable than some stuff posted in forums. They provide general legal information and tell you when you can use a free license In short, it is if your application is distributed under a FOSS license. and when you have to buy a commercial one.


4

The 'client only' means that two Express instances cannot communicate directly. They have to have a Standard instance in between acting as a forwarder. Express instances can both generate and consume messages. Messages originating on Express instances can be received on Standard or higher instances. Messages originating on Standard or higher instance can ...


4

Licensing is "per CPU" or "Server/Cal". Per CPU is for any number of users Server/CAL requires 1 CAL per user. Not concurrent users: any user who will use SQL Server It is all contained here in this MS PDF


3

From the document, the important paragraph is: To setup a remote mirroring environment, the Oracle data files, executables, binaries and DLLs are replicated to the mirrored storage unit. Solutions like Veritas Volume Replicator, EMC SRDF, Legato Replistor, and EMS StoreEdge are used to mirror the data stored on the disk arrays. Emphasis ...


3

Go with standard edition, Server/CAL model. The server license is around $1800, each CAL is about $150. Only buy CAL's if you actually need them. Single CPU licence is about $5000. That model would work for you if you have 1 CPU in your server but lots of cores to actually do the work. A CPU is for the actual physical socket (unless the license model ...


3

Another thing that you could do that was even more economical is to use the developer edition and then run the following query against the database before deploying: SELECT * FROM sys.dm_db_persisted_sku_features This will then tell you if you are using a feature that is not supported in all editions of SQL server, so if this returns no rows, you are ok ...


3

Short version: no. Active Data Guard is an optional feature that allows you to open the standby database in read-only mode while applying logs from the primary. If you need the standby database only in case of disaster, then you don't need to buy this option.


3

You should call a Microsoft licensing expert and talk to them. They would be best person to resolve all your queries. Microsoft licensing is bit comlex and varies per environment. I have 2 servers and I'm looking to have the first as a Primary and the second as a mirror (as a reporting server and DR server), from what I can see on Microsoft's comparisons ...


3

The correct answer for licensing questions is: contact your oracle sales representative. With Oracle you license cpu's. If your test and prod run on the same cpu's, they don't need a new license. As long as it all runs on the same cpu's, it does not matter if you have multiple databases (and instances) or run it all in one single database. Normally we don't ...


2

Microsoft gives Downgrade Rights to Volume Licensing customers and, to some extent, even to OEM and retail customers. However, in general, if you don't have a Volume License, you can't have the bits and the product key, which are necessary to excercise your downgrade rights. Long story short, if you want 2008 R2, you'll have to buy it. Here's a blog ...


2

I would rephrase your question to what is likely to make my company shell out all the extra cash for Enterprise edition? Well it depends on the version of SQL server but below is a list of features and reasons that businesses upgrade for. SQL 2012 Standard is limited to 64 GB of RAM SQL 2014 Standard is limited to 128 GB of RAM Standard is limited to 2 ...


2

Start using your licenses in a smart way. Many customers buy EE licenses, only using SE features. Don't underestimate the power of SE. You can use SE with a max of 4 sockets and with modern CPU's that's a lot of power. SE1 has a max of 2 sockets. See Database Licensing - Oracle Next to that, consider consolidating your smaller applications into 1 serious ...


2

At the risk of stating the obvious, nothing is physical in Azure as far as you are concerned. The best thing you can do is go to the Azure Pricing Calculator, find the 'SQL Server' section, select the 'Standard' section, find D-Series, select 'D4' and slide the slider to 1. That's what you will be paying, eg SQL Server will treat that box as having 8 ...


2

Do you mean upgrade from Evaluation to the full Enterprise? If so, then yes that is supported. Take a look at the link here on BOL to show supported edition upgrades (scroll towards the bottom, it has SQL Server 2014 upgrades between editions and what's possible).


2

Run SELECT @@VERSION; in a query window, with results to text. You will see something like this (minor details will vary) in the Messages pane: Microsoft SQL Server 2014 - 12.0.2402.0 (X64) Aug 13 2014 11:36:34 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.4 <X64> (Build 9841: ) ----^^^^^^^^^ edition will ...



Only top voted, non community-wiki answers of a minimum length are eligible