Jump to content



Photo

SQL Server 2008 R2 Express or Developer?


  • Please log in to reply
4 replies to this topic

#1 dtytfyiutiufg

dtytfyiutiufg

    Neowinian

  • Joined: 24-December 02

Posted 09 October 2012 - 09:34

I am looking to learn MS SQL (together with C#) but was wondering which version I should install?

I have Developer via Dreamspark so just wondered if I would be better off installing the Developer edition over Express for the additional features and similarity to SQL Standard edition.


#2 garethevans1986

garethevans1986

    Neowinian

  • Joined: 01-April 04
  • Location: Gogledd Cymru / North Wales

Posted 09 October 2012 - 13:21

The minimum you need is SQL Express + SQL Management Studio.

GE

#3 OP dtytfyiutiufg

dtytfyiutiufg

    Neowinian

  • Joined: 24-December 02

Posted 09 October 2012 - 14:40

Yeah I am aware of the minimum I need I was just wondering if using a full version of SQL Server instead of the Express edition would be a better idea for learning? I am new to C# however will be working with SQL data sources soon and figure that in the "real world" I will be working with SQL Server Standard or above for most things so the Developer version seems like a better choice?

#4 Kami-

Kami-

    ♫ d(-_-)b ♫

  • Tech Issues Solved: 2
  • Joined: 28-July 08
  • Location: SandBox

Posted 09 October 2012 - 18:10

Yes much better; especially if you plan to use SQL in an enterprise/business environment some day.

Express is free (to everyone) for a reason.

#5 BGM

BGM

    Wibble Wobble™

  • Joined: 30-March 03
  • Location: Farnborough, UK

Posted 09 October 2012 - 18:29

get express if yo uare literally just starting out, dev will have so many features you will never use.

then... move to dev and start using some of the advanced features. it has the same stuff as enterprise, just you are not allowed to use it in production :)

good luck.



Click here to login or here to register to remove this ad, it's free!