newbie needs help with different SQL versions

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: JSE (john_at_nospam.ca)
Date: 08/16/04 

Date: Mon, 16 Aug 2004 18:33:23 GMT

Hello everyone.

I am brand new to the "SQL" and SQL software, and don't know very much about
it.

I am considering purchasing an network enterprise application that requires
Windows SQL Server 2000, but a single user version of this application will
work with MSDE (desktop) on a standalone machine. I need to find out what
needs to be running on my standalone machine before I go out and buy this
application...... and I have a few questions.

Q. What is a SQL Developer Edition? What is it used for? Do I need
it?

Q. If I install a SQL developer on a standalone machine, would it take the
place of MSDE, or must the developer run on a machine with MSDE software
already running?

Q. If I were to install this application (enterprise edition) on a
network, would a developer take the place of Windows SQL Server 2000 or must
the developer run on a machine with Windows SQL Server software already
running?

The reason for my concern is because the price of the Windows SQL Server
2000 is high, but the developer edition is low, .... which leads me to
believe that you must run the developer on a system that already is running
SQL Server or MSDE. Is this correct?

If anyone can help me out here I'd really appreciate it.

Thanks very much,

John

Relevant Pages

  • Re: Dont understand what version of SQL to install
    ... Subscription and I still have to pay $49 to use SQL Developer? ... I don't think you have to buy another license for the Developer Edition, but you better ask this question to whom you bought it. ... it's not stated that SQL Server 2008 Enterprise Edition can be ... > So I can use SQL Developer 2008 to create a database in standard 2005, ...
    (microsoft.public.sqlserver.setup)
  • Re: Dont understand what version of SQL to install
    ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Cool SQL Presentation At IDUG North America
    ... They have developer resources for just the kind of queries you are referring to, and show you how to place addresses on the Google Earth map. ... Cool SQL Presentation At IDUG North America ...
    (comp.databases.informix)
  • Re: Dont understand what version of SQL to install
    ... I created a database using sql 2005 express edition. ... With that in mind - could you use SQL Server 2008 Developer Edition? ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Dont understand what version of SQL to install
    ... You can probably install it on Windows XP as well but I have not tried it yet. ... Actually, if you investigate the documents on Books Online, it's not stated that SQL Server 2008 Enterprise Edition can be installed on Windows XP nor Vista. ... I suggest you to use SQL Server 2008 Developer Edition to create databases for your SQL Server 2005 and 2008 database applications. ...
    (microsoft.public.sqlserver.setup)