473,586 Members | 2,707 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

What version of SQL Server to buy?

I am a single developer, and new to SQL Server. I have Windows XP Pro, and
my system has a couple gigs RAM. I would like to know what version of SQL
Server I should buy. Any advice is appreciated.
Aug 3 '07 #1
14 2011
On Fri, 3 Aug 2007 18:21:03 -0400, Charlie wrote:
>I am a single developer, and new to SQL Server. I have Windows XP Pro, and
my system has a couple gigs RAM. I would like to know what version of SQL
Server I should buy. Any advice is appreciated.
Hi Charlie,

If you're going to use it for development, buy the developer edition.
This gets you all the features of the enterprise edition, but licensed
only for development work. It'll cost you about $50.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Aug 3 '07 #2
Hugo Kornelis wrote:
On Fri, 3 Aug 2007 18:21:03 -0400, Charlie wrote:
>I am a single developer, and new to SQL Server. I have Windows XP Pro, and
my system has a couple gigs RAM. I would like to know what version of SQL
Server I should buy. Any advice is appreciated.

Hi Charlie,

If you're going to use it for development, buy the developer edition.
This gets you all the features of the enterprise edition, but licensed
only for development work. It'll cost you about $50.

--
Wes Groleau

http://Ideas.Lang-Learn.us/
For lovers of language and learning
Aug 4 '07 #3
Charlie wrote:
I am a single developer, and new to SQL Server. I have Windows XP Pro, and
my system has a couple gigs RAM. I would like to know what version of SQL
Server I should buy. Any advice is appreciated.
Get the free version and use it until you figure out
which missing features you need. Then upgrade.

--
Wes Groleau

You're all individuals!
Yes, we're all individuals!
You're all different!
Yes, we are all different!
I'm not!

("Life of Brian")

Aug 4 '07 #4
I have the free version. What advantage is the developer version over the
free version? I am having trouble creating table relationships in the free
version. Any advice?

Charlie

"Wes Groleau" <gr**********@f reeshell.orgwro te in message
news:j5%si.178$ Aj6.167@trnddc0 1...
Charlie wrote:
>I am a single developer, and new to SQL Server. I have Windows XP Pro,
and my system has a couple gigs RAM. I would like to know what version of
SQL Server I should buy. Any advice is appreciated.

Get the free version and use it until you figure out
which missing features you need. Then upgrade.

--
Wes Groleau

You're all individuals!
Yes, we're all individuals!
You're all different!
Yes, we are all different!
I'm not!

("Life of Brian")

Aug 4 '07 #5
Charlie wrote:
I have the free version. What advantage is the developer version over the
free version?
In that case, my advice would be to read the feature comparisons
on Microsoft's website.

--
Wes Groleau

He that is good for making excuses, is seldom good for anything else.
-- Benjamin Franklin
Aug 5 '07 #6
On Aug 3, 3:21 pm, "Charlie" <jadki...@yahoo .comwrote:
I am a single developer, and new to SQL Server. I have Windows XP Pro, and
my system has a couple gigs RAM. I would like to know what version of SQL
Server I should buy. Any advice is appreciated.
yeah, developer version is probably the best choice. The enterprise
actually won't install on XP (only Windows Server)

Aug 5 '07 #7
Interesting that the Microsoft web site doesn't include the developer
version in the comparison.

Charlie

"Wes Groleau" <gr**********@f reeshell.orgwro te in message
news:9cati.3799 $J13.2715@trndd c02...
Charlie wrote:
>I have the free version. What advantage is the developer version over the
free version?

In that case, my advice would be to read the feature comparisons
on Microsoft's website.

--
Wes Groleau

He that is good for making excuses, is seldom good for anything else.
-- Benjamin Franklin

Aug 5 '07 #8
On Sun, 5 Aug 2007 12:17:04 -0400, Charlie wrote:
>Interesting that the Microsoft web site doesn't include the developer
version in the comparison.
Hi Charlie,

Yeah, I've been bitten by that one as well. Actually, the reason is (or
was, last time I looked) mentioned on one of the comparison pages, but
buried deep in the small print so I can't blame you for not finding it!

The reason that developer edition is not included on the feature
comparison pages, is that developer edition has the exact same features
as the enterprise edition! The only differences are price, license, and
(as Bucky points out) supported operating systems - but those
characteristics are mentioned on other pages, where developer edition is
indeed included!

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Aug 5 '07 #9
On Sat, 4 Aug 2007 15:30:02 -0400, Charlie wrote:
>I have the free version. What advantage is the developer version over the
free version? I am having trouble creating table relationships in the free
version. Any advice?
Hi Charlie,

WRT relationships, the Express Edtion has the same features as any of
the other editions.

In case you haven't yet done so, you might want to download and install
Management Studio Express, a graphical interface exposing many of SQL
Server Express' features. For some, using a GUI is great. For many other
features, I wouldn't want to touch a GUI with a 10' pole, since writing
straight SQL gives me so much more control.

Using a GUI and then checking the generated SQL *can* be a way to learn
writing SQL, but beware that it's also a great to to learn to write bad
SQL, as some of the stuff that the GUI generates is terrible. You might
be better off buying (or borrowing) and reading a text book to write to
learn SQL.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Aug 5 '07 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
630
by: j.b.messina | last post by:
This has not yet been published by Microsoft. It will be published within the next few weeks, mainly because I asked them to. I felt this was information badly needed, and I think this is the best group to share this information. A co-worker and I were able to determine how to tell exactly what version of .NET Framework is installed. We...
121
9988
by: typingcat | last post by:
First of all, I'm an Asian and I need to input Japanese, Korean and so on. I've tried many PHP IDEs today, but almost non of them supported Unicode (UTF-8) file. I've found that the only Unicode support IDEs are DreamWeaver 8 and Zend PHP Studio. DreamWeaver provides full support for Unicode. However, DreamWeaver is a web editor rather...
47
4505
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small company and this is a big decision for us(!) It's not just the money it's committing to an new version of Access!
3
1462
by: mminnie | last post by:
After years of working with legacy systems, I am not starting to discover the .NET world. Wow. I am trying to figure out how Visual Basic, Windows Forms, Smart Clients, and all of the other .NET technologies work together. Here is what I want: I want a powerful desktop application with a rich user interface to read and write data on a...
2
1771
by: Hongbo | last post by:
Hi, I have a web site built in ASP.Net 1.1 running on production server. It's the version 1.0. Now I need to build the version 2.0 for this web site. The version 2.0 will be built based on the code of version 1.0. Since it take some time to have the version 2.0 ready for production, the code of version 1.0 needs to be kept somewhere for...
9
19686
by: Rico | last post by:
Hello, I have an application which I'd like to determine if SQL Server is installed, and if so, what version. Is there any way to do this outside of error trapping? Thanks! Rick
1
1301
by: Robert Dufour | last post by:
If I use Dim Myconn as new sqlclient.connection Dim srvVer as string srvVer = MyConn.serverversion What should I get back as string if I was connected to sql server 2000 (standard full version) what would I get back if it was sqlserver 2005 (standard full version) are the returend strings different for the sql server developper editions...
5
1418
by: Aggelos | last post by:
I want to start developing a simple Content Management System and having done that before I know there is a point where you can't manage different versions of applications unless you have a sollution like version control. I was thinking of having something like one installation for the whole server, but some of you said that this might have...
2
1800
by: JosAH | last post by:
I run my Java programs on a small Linux laptop and today I installed it again on a MS Vista laptop.My linux laptop ran quite a bit faster than my Vista laptop and I decided to find out why. After a bit of digging I found out that the 'server' hotspot comes with the Linux JRE distribution but it isn't there in the MS Windows distribution; it...
0
7912
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
1
7959
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8216
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6614
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5710
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5390
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3837
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2345
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1449
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.