SQL Developer licensing

Question

SQL Developer licensing

Andrew Collins

Ten Centuries

Points: 1369
More actions
January 25, 2012 at 8:02 am

#255552

We have a sql 2008R2 Developer edition , and would like to have a linked server to a Live server to access data. is this allowed with developer license?
alternativly would we be allowed to replicate the data from live to developer?

Viewing 15 posts - 1 through 15 (of 24 total)

You must be logged in to reply to this topic. Login to reply

Brandie Tarvin SSC Guru Points: 173045 More actions · Answer 1

Andrew Collins (1/25/2012)
We have a sql 2008R2 Developer edition , and would like to have a linked server to a Live server to access data. is this allowed with developer license?

If you asked Microsoft, the answer would be "No."

alternativly would we be allowed to replicate the data from live to developer?

Again, if you asked Microsoft, the answer would be "No." As I'm not a lawyer, I'm not even going to try interpreting the license and just agree with "No."

You can, however, backup your live db and restore it to a dev server on a daily basis in order to develop whatever you items you need. But you cannot use Dev in conjunction with a live database so far as I know.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Robert Murphy UK1 Default port Points: 1485 More actions · Answer 2

This is allowed. The restriction is you are not allowed to use the development server to serve data to production applications / clients. Loading data from live to development is fine.

*** Oh and so long as you are replicating the data there for development purposes and not a disaster recovery solution 😎

Robert Murphy, Microsoft MCITP (Database Administrator 2008) and MCAD Certified

Andrew Collins Ten Centuries Points: 1369 More actions · Answer 3

thanks, do you have any microsoft links which would provide this information?

Brandie Tarvin SSC Guru Points: 173045 More actions · Answer 4

Here's the R2 link: http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx

Microsoft is making really hard to find the SQL 2008 regular stuff, but here's what I grabbed off Google. It's a download document, so be careful clicking the link If you don't want to download something.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Andrew Collins Ten Centuries Points: 1369 More actions · Answer 5

thanks

unfortunatly i need a difinitive answer from a microsoft document tlling me if i can or cant either use linked server or replicate to a dev edition of sql2008R2

Steve Jones - SSC Editor SSC Guru Points: 736078 More actions · Answer 6

Call MS. They do not document this stuff well, mostly I think to avoid people gaming the system.

AFAIK, you cannot use development stuff for production. They are fairly liberal on allowing development licenses, or even free licenses for testing/dev work, but not if you are moving live data.

That would violate the spirit of the agreements, although I don't know I think the agreements are fair in some cases.

Find the licensing people in your country: http://mslicense.com/

Revenant SSC-Forever Points: 42467 More actions · Answer 7

Email <>, Executive Assistant to <>, and ask her to forward your question to whoever can answer it.

Please don't forget to stress that you are writing only after you have done extensive search, opened a topic on SQLSC, etc.

Lowell SSC Guru Points: 323518 More actions · Answer 8

here's my two cents.

a linked server is just a connection to a licensed server.

no different from whether i connect via an application i create, or from a developer edition.

if i consume the data within Developer Edition, no problem.

if other people connect to my Developer Edition to do work and not develop, THAT's the problem.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Brandie Tarvin SSC Guru Points: 173045 More actions · Answer 9

Robert Murphy UK1 (1/25/2012)
*** Oh and so long as you are replicating the data there for development purposes and not a disaster recovery solution 😎

Can I just add, for anyone reading this thread in the future...

Linked servers and database replication are NOT (never have been and never will be) Disaster Recovery Solutions. Please, please, please, do not ever equate DRS to replication or data pulls via linked servers.

I know Robert knows better, but some people may mistake his remarks about other people's poor business practices to mean that replication is an acceptable DRS.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Andrew Collins Ten Centuries Points: 1369 More actions · Answer 10

The reason for the LInked server (or replication ) in our case is for a BI and reporting server

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 11

As in a production BI and reporting server? If that's the case, no you cannot use Developer edition for that, it's a production usage and the developer license is for non-production usage

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Andrew Collins Ten Centuries Points: 1369 More actions · Answer 12

it will initially be used as a development BI reporting accessing data from live, when dev is complete we will change to enterprise

Jared SSC Guru Points: 61793 More actions · Answer 13

Brandie Tarvin (1/25/2012)
mean that replication is an acceptable DRS.

For my own understanding... I assume you mean database DR, as I can see this being an acceptable solution for site outage; i.e. One site in Chicago replicates to New York where Chicago is publisher. Bad storm causes some type of outage where traffic for application is now automatically routed from Chicago to New York. Would you consider this to be a poor solution?

Jared
CE - Microsoft

Gazareth One Orange Chip Points: 27737 More actions · Answer 14

If you're using SSRS, why use a linked server at all? Just create datasources pointed at the production server.

Licensing, I'm not sure on. If the reports are only accessed by devs, you might be ok. I suspect not though.

Shaky ground methinks!