SQL Server 2005: Express or Developer?

18 Aug 2006 5:30 PM

MC

I'm familiar with SQL Server 2000 but not with any of the 2005
editions. My company is switching from a Java/Linux platform to a
Microsoft one and I'm building a developer's workstation software
configuation. For database tools, does it make any sense to go with
the Express edition of SQL Server 2005 (plus the Express Manager,
which seems to be a separate download, not included with VS2005) or
should I install some "client" subset of SQL Server 2005 Developer
Edition? I see a checkbox in the setup called "Workstation
components, Books Online and development tools". Is this what people
usually choose?

Thanks for any help,
Craig

18 Aug 2006 6:24 PM

Arnie Rowland

For developers workstations: normally all that is needed is the 'Client
tools', Books Online, etc., -and an development SQL Server on the network.

And you may wish to look at getting the Developers Edition of SQL Server.
Unlike the Express Edition, it is the same as Enterprise Edition -with all
of the robust client and developer tools necessary for most any type of SQL
Server development.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

Show quote

"MC" <nospam@nowhere.com> wrote in message
news:fstbe2l7luto8b407d2oacvg31dh0qepn4@4ax.com...
> I'm familiar with SQL Server 2000 but not with any of the 2005
> editions. My company is switching from a Java/Linux platform to a
> Microsoft one and I'm building a developer's workstation software
> configuation. For database tools, does it make any sense to go with
> the Express edition of SQL Server 2005 (plus the Express Manager,
> which seems to be a separate download, not included with VS2005) or
> should I install some "client" subset of SQL Server 2005 Developer
> Edition? I see a checkbox in the setup called "Workstation
> components, Books Online and development tools". Is this what people
> usually choose?
>
> Thanks for any help,
> Craig