A Developer’s Guide to Installing SQL Server 2005 – Part 1 – Selecting a version

As a developer of applications that use SQL Server in some way, it can be valuable to have a database local to your box. It can be used for development, testing, or debugging in an off line environment. While there are many versions of SQL Server 2005, there are only two versions that are really suitable for the developer’s computer: SQL Server Express With Advanced Options, and SQL Server Developers Edition.

The first, SQL Server 2005 Express, is free. There are actually two versions of Express, the standard and the one entitled SQL Server 2005 Express Edition with Advanced Services SP2. It can be a little hard to find, so here’s a handy link: http://msdn2.microsoft.com/en-us/express/bb410792.aspx The standard edition does not include Full Text Search, Reporting Services, or the SQL Server Management Studio Express. These are all features that you, as a developer will want.

The other version of SQL Server that’s geared toward developers is the SQL Server 2005 Developer Edition. This version has the same features as the Enterprise Edition, but it’s only licensed for a single developer to access. It also comes with the full blown BIDS (Business Intelligence Developer Studio) tools. It’s not free, however it’s not expensive either. At only 49.99 it’s priced so even a small one person development shop can easily afford it. This link has more info, including a link to purchase:

http://www.microsoft.com/products/info/product.aspx?view=22&pcid=f544888c-2638-48ed-9f0f-d814e8b93ca0&type=ovr

If you have an MSDN License, the SQL Server 2005 Developer Edition is included with it and can be downloaded via your subscription.

So as a developer, which version version should you install? That answer is easy. Both.

Yes, both. The Express edition will allow you to perform small scale testing, let multiple users bang away at your solution and let you perform some small measure of scalability testing. With it’s database size limited to 4 gig, it may nor may not be big enough to hold your entire database, but it’s certainly large enough for a good hunk of your data. The Developer Edition will give you all of the tools and let you emulate your Enterprise system, at least in terms of the database sizes and structures. However since it’s licensed only for the developer, you won’t be able to have multiple users access it.

So you’ve decided OK, you want to install. If you’re not a trained DBA there a few gotcha’s you should know about when installing SQL Server. By default, not all of the features are installed. In the next few posts, I’ll show step by step instructions on how to install SQL Server for your development workstation.

Advertisements

8 Responses to “A Developer’s Guide to Installing SQL Server 2005 – Part 1 – Selecting a version”

  1. Daily Facts Says:

    Guess what? Your blog is amazing! I can’t remember when was the last time i’ve overcome such a good blog that almost all articles/posts were interesting and wouldn’t regret spending my time reading it. I hope you will keep up the great work you are doing here and i can enjoy my everyday read at your blog.

  2. Stephen Swan Says:

    Does the developer edition allow multiple developer licenses against the same instance on a server?

  3. Helen Says:

    I phoned Microsoft and asked about the licensing of the Developer Edition since I wanted 2 developers to be able to access the same dev environment. They advised that I could purchase 2 copies of the Dev edition to allow this as the licence is ‘per developer’

  4. naresh Says:

    sql server 2005mdeveloper

  5. Kevin Says:

    Hi,
    could you answer a question for me…
    is there 2 different flavors of SQL 2005 Developer
    64 and 32?

    thanks.

  6. Diomedes Dominguez Says:

    This it’s the real link to Microsoft SQL Server 2005 Express Edition with Advanced Services

    http://www.microsoft.com/downloads/details.aspx?familyid=4C6BA9FD-319A-4887-BC75-3B02B5E48A40&displaylang=en

  7. Steven Says:

    hi, I would like to ask a question. I have MSDN license, am I able to use business intelligence developement studio after i install sql server 2005 developer version?

  8. arcanecode Says:

    Steven, Yes you will be able to use BIDS after installing the Developer Version. If you don’t have Visual Studio 2005 installed, it will install the VS 2005 shell then the BIDS components. If you have VS2005 installed already, it simply adds the BIDS bits to your existing install.

    Please note that to develop BIDS for SQL Server 2005, you must use VS2005, and likewise with 2008.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: