Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is SQL Server Express good enough for a developer, or should they get Developer edition?

Tags:

sql-server

Just wondering if it's worth it for a developer to use SQL Server 2005/2008 Developer Edition instead of the bundled SQL Server Express edition that comes with Visual Studio. I'm talking about for initial development of a website, where you need to create SQL scripts to generate the tables and things like that. I know with Express it's easy to add an .mdf file to your project and program against that, but wouldn't it be better to install Developer edition and program against a "real" database that would mimic what you're going to be using in production? That way if you're using VS Professional and can create a "database project" you can include all of your creation scripts and run them in production to recreate the environment.

like image 929
Jack Of Hearts Avatar asked Feb 21 '09 23:02

Jack Of Hearts


People also ask

Should I use SQL Server Express or developer?

SQL Server Developer is an ideal choice for people who build and test applications. Express edition is the entry-level, free database and is ideal for learning and building desktop and small server data-driven applications.

What is the difference between SQL Express and Developer Edition?

What is the difference between the SQL Server Express Edition and the Developer Edition? Both editions are free editions, but the Express edition has limited functionality whereas the Developer Edition does not have any limitations compared with an enterprise.

Is SQL Server Express good enough?

SQL Server Express is a great choice for small-scale, cost-effective multi-user database implementations. It can run on both Windows® desktop operating systems like Windows 7, 8, 8.1, and 10, as well as server operating systems like Windows Server 2008, 2008 R2, 2012, and 2012 R2.

What is the difference between SQL Server Standard Edition and Express Edition?

SQL Express is free, but requires a bit more RAM to perform well. SQL Standard has a licence costs but Your Office Anywhere are able to significantly reduce the licence burden for customers by using data centre licences and running multiple secure instances of SQL on multi-tenanted servers.


1 Answers

If you have access to it, you're better off using Developer Edition because it supports more features and larger databases. For example, if you want to restore a 50gb database from your production server onto your workstation to do testing, you'll need Developer Edition.

Another example is if you're working with Enterprise-only features like partitioning, compression or the Resource Governor. Those features aren't available in Express, but they are available in Developer Edition.

like image 55
Brent Ozar Avatar answered Nov 04 '22 19:11

Brent Ozar