SQL Server 2008 R2 developer edition question

  • OK, so now I have got my book on 70-433 and if/when I take the exam this will be my first formal study approach to SQL Server after having spent most of my time with Access.

    At the back of the MS book is the disk for SQL Server 2008 Enterprise evaluation edition that lasts for 180 days. My guess is that this has now been superseded by 2008 R2, so the R2's may be the better editions to be practising on now.

    I have been looking at the developer edition and if I have read the licensing properly, it can be installed on more than one computer, so long as it is not used in a production environment?

    Can't seem to find a download link for the developer edition. I also guess it will suffice for practising for the exam. Does it also come with Business Intelligence Development Studio?

  • SQL Server 2008 R2 Developer Edition is not free! It is around $50.00 and can be bought from MS or amazon etc;

    http://www.amazon.com/s/ref=nb_sb_ss_i_0_21?url=search-alias%3Daps&field-keywords=sql+server+developer+edition&sprefix=sql+server+developer+

    The trial you have is exactly that a trial and will need to be upgraded (by purchasing a license key).

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • Developer edition does offer all the features of Enterprise just not for a prod environment

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Looks like I may have to buy it.

    Is it feasible to install 2008 evaluation, and then remove it and install 2008 R2 developer at a later date?

    When I tried having 2008 R2 & 2005 on the same pc, everything messed up and I had to reinstall my o/s, which I'd rather not go through again...

  • meridius10 (9/5/2011)


    Looks like I may have to buy it.

    Is it feasible to install 2008 evaluation, and then remove it and install 2008 R2 developer at a later date?

    When I tried having 2008 R2 & 2005 on the same pc, everything messed up and I had to reinstall my o/s, which I'd rather not go through again...

    How did it mess you PC? Did you have it on your PC beyond the evaluation period?

    I heard that if the evaluation edition expires on 2008+ your #@#&.

    You may want to install the SQL Server R2 Evaluation Edition.

    If you can cough up the $49 USD for the SQL Server 2008 R2 Edition that would be your best bet.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • Install the evaluation version, save all your scripts which you use during the trial, uninstall the evaluation and install SQL Server 2008 R2 Developer.

    There should be no problems caused by doing this.

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • Well it was a functionality issue and certain things were not working on 2005 and 2008 R2. I then calculated it would be more work to try and fix the problem than reinstall the os and the MS instructions were so complicated that there was no point.

    I will be taking no risks this time.

    Have noticed that there is no trial download for developer edition and it looks like the only way to order it is through the internet.

  • The exams are based on SQL 2008, not SQL 2008 R2.

    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
  • Is it not better to learn the latest version unless there is a huge difference between both and this has an effect on training for the exam?

    The other option may be just to reinstall the trial version before or once the trial is up, if this is possible, unless I have to clean the registry first.

  • Is it not better to learn the latest version unless there is a huge difference between both and this has an effect on training for the exam?

    With the exception of the BI side (power pivot, master data services, etc, etc), SQL 2008 is virtually the same as SQL 2008 R2.

    The other option may be just to reinstall the trial version before or once the trial is up, if this is possible, unless I have to clean the registry first.

    Um, that's called a licensing violation. If you want to risk the fines and other consequences of that, go right ahead. It's a 180 day trial, that's 6 months. If you need to use SQL for more than 6 months, fork out that $50 and buy a legit copy.

    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
  • GilaMonster (9/5/2011)


    Is it not better to learn the latest version unless there is a huge difference between both and this has an effect on training for the exam?

    With the exception of the BI side (power pivot, master data services, etc, etc), SQL 2008 is virtually the same as SQL 2008 R2.

    The other option may be just to reinstall the trial version before or once the trial is up, if this is possible, unless I have to clean the registry first.

    Um, that's called a licensing violation. If you want to risk the fines and other consequences of that, go right ahead. It's a 180 day trial, that's 6 months. If you need to use SQL for more than 6 months, fork out that $50 and buy a legit copy.

    I agree with Gail, for the $50 you will be able to enjoy all the features of the Enterprise Edition, so why not buy it?

  • I think it will make sense to buy it. $50 isn't so much for such a powerful app.

Viewing 12 posts - 1 through 11 (of 11 total)

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