Re: Don't understand what version of SQL to install

Tech-Archive recommends: Speed Up your PC by fixing your registry

I just purchased Visual Studio 2008 Professional with the Premiun MSDN
Subscription and I still have to pay $49 to use SQL Developer?

This is my first post to this newsgroup. Is there a place to make as Answered?

Thanks Ekrem.
Terry

"Ekrem Önsoy" wrote:

To my Vista, I can use the SQL Enterprise 2008 version.

Technically Correct. 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. Some MSFT said that Enterprise Edition of
2008 can be installed on Client OSs, the limitation is removed but it's not
a suggested configuration.

So I can use SQL Developer 2008 to create a database in standard 2005,
then
an hour later, I can easily use it to develop a express 2008 database? If
so,
awesome.

Yes but you should know that there's any any constructural difference
between databases which are created in Standard Edition or Express Edition
or Enterprise Edition. The difference is all about the features of the
different Editions and Versions. Actually, I think Geoff tried to mention
this in his reply. For instance, you can use Partitioning only in Enterprise
and Developer Editions of SQL Server. If your database application consists
this feature, then you can not use this application in a Standard Edition.
This was an example in terms of different Editions. When it comes to
different Versions (for instance 2005 and 2008), if you create a database
application in a 2008 version instance of SQL Server which uses new data
types (such as Time or Date) you'll have problems when you try to use it for
a SQL Server 2005 version (edition doesn't matter) instance of SQL Server. I
just want to ensure that you know the possible problems and aspects about
the different editions and different versions of SQL Server.

In a nutshell, I suggest you to use SQL Server 2008 Developer Edition to
create databases for your SQL Server 2005 and 2008 database applications. To
have a better understanding about the differences of the SQL Server
editions, see the links I provided before and to see the new features of SQL
Server 2008, see this link:
http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx

I just don't know how to change things to 90. But, your links should
answer
all that.

To change a database's Compatibility Level, you can use SQL Server
Management Studio (the GUI to manage SQL Server databases and instances).
Simply, right click on a database and from Properties, go to Options.

Or, use T-SQL. Sample : EXEC dbo.sp_dbcmptlevel @dbname=N'Test',
@new_cmptlevel=90

One more question, please...
What are the benefits of using the Enterprise edition over the Developer
Edition using my vista system?

I repeat, for development, demo and test purposes Developer Edition should
be used. Enterprise Edition is for production servers, not for developers.
Also, Developer Edition' s per-developer license cost is about 49$. But
Enterprise Edition's license cost is about thousands of $. See pricing
documentation: http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx

--
Ekrem Önsoy - SQL Server MVP


"VeganMan" <VeganMan@xxxxxxxxxxxxxxxxxxxxxxxxx>, iletisinde şunu yazdı,
news:59D49338-E994-4F34-BDE9-C3BB3F5C8BF1@xxxxxxxxxxxxxxxx
Hi Ekrem, thanks for being specific.

I'm talking about developing and testing databases for my client and
deploying them on their website. I don't have any access to installing
programs on their servers, as far as I know anyway. So I will not be
installing SQL on anyones server. I'm not just where you got that
impression.
Perhaps I'm not using the right lingal. I'm very new with asp.net and
using
databases. As a matter of fact, I just created my first one but haven't
deployed it yet. (Using the express edition). I haven't even downloaded
any
programs from MSDN yet, other than VS Pro, a couple days ago.

Just to confirm before I maked this as answered:

To my XP, I can add SQL Developer 2008 to develop (I guess I should say,
"Design") and test databases, including 2005. (I can remove sql express)

To my Vita, I can use the SQL Enterprise 2008 version.

So I can use SQL Developer 2008 to create a database in standard 2005,
then
an hour later, I can easily use it to develop a express 2008 database? If
so,
awesome.

I just don't know how to change things to 90. But, your links should
answer
all that.

One more question, please...
What are the benefits of using the Enterprise edition over the Developer
Edition using my vista system?

Terry

Thanks a head of time, Ekrem.

"Ekrem Önsoy" wrote:

I use two computers for development, on using XP and the other using
Vista,
so I know I cannot use the Enterprise version of SQL, CORRECT?

Not correct literally, because SQL Server 2008 Enterprise Edition can be
installed on Client OSs such as Windows Vista. This was a limitation for
Enterprise Editions of SQL Server 2005 and below.

In your first post you said mentioned creating your clients' databases,
is
that it? I mean are your clients going to be connecting to your SQL
Server
Instance where you perform your development tasks? In this case, you can
not
use Developer Edition because it's against the license agreement. This
edition of SQL Server is only for one user per license and it's intended
for
development, test and demo purposes.

If I install the Developer 2008 Edition, can I create databases on the
needs
of all eight clients, as above? EG: A client needs to have an express
2005
database created, can I use SQL Developer 2008 to create and test it?

Yes. By changing the compatibility level of the database to 90.

I can't use the developer 2005 edition for anything using any 2008
versions,
CORRECT?

If you mean creating 2008 version databases then correct, you can't use a
2005 version instance for that puspose. Because new features of 2008 are
not
included in the previous version.

To sum up, if I install the sql developer edition 2008, can I create
databases for all versions in year 2005 and 2008 without the need to
install
other version, even the express editions, if not, could you explain
please?

Yes, you don't need to install other version or editions. 2008 version
Developer Edition would be sufficient. However see my above comment about
licensing. Simply, you can't use this Edition of SQL Server as a "server"
where users connect in a production environment. This can be done only
for
test purposes.

I suggest you to see the Comparison Tables:

For SQL Server 2005:
http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

For SQL Server 2008:
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

--
Ekrem Önsoy - SQL Server MVP



"VeganMan" <VeganMan@xxxxxxxxxxxxxxxxxxxxxxxxx>, iletisinde şunu yazdı,
news:0613E2A1-F02E-48B2-AB62-E6CDDE803E97@xxxxxxxxxxxxxxxx
Thanks for responding Geoff. But I don't understand what you are
saying.

I spend the entire weekend looking for a answer and still haven't found
it.
However, I did find out that I cannot use the enterprise edition due to
only
having XP and Vista.

So I'm down to installing the Developer Edition.

I may not understand your response due to you not understanding my
question,
perhaps... So I will ask in a different way. I hope you don't mind
responding
again.

Let's say I have eight clients:

Client 1 uses Sql Express 2008
Client 2 uses Sql Express 2005
Client 3 uses Sql Workgroup 2008
Client 4 uses Sql Workgroup 2008
Client 5 uses Sql Standard 2008
Client 6 uses Sql Standard 2005
Client 7 uses Sql Enterprise 2008
Client 8 uses Sql Enterprise 2005

Have I missed anything???

I use two computers for development, on using XP and the other using
Vista,
so I know I cannot use the Enterprise version of SQL, CORRECT?

I can't use the developer 2005 edition for anything using any 2008
versions,
CORRECT?

If I install the Developer 2008 Edition, can I create databases on the
needs
of all eight clients, as above? EG: A client needs to have an express
2005
database created, can I use SQL Developer 2008 to create and test it?

To sum up, if I install the sql developer edition 2008, can I create
databases for all versions in year 2005 and 2008 without the need to
install
other version, even the express editions, if not, could you explain
please?

Sorry for my lengthly explaination. I just want to be sure I have all
my
basis covered.

Thanks,
Terry

"Geoff N. Hiten" wrote:

Unless you use an on-disk structure unique to Enterprise Edition such
as
partitioning, you can move databases up and down Editions at will. A
SQL
EE
database can be moved to SQL Express (provided it does not exceed the
maximum size limitation of express).

Typically, I use Developer Edition to create the databases and then
test
them on whatever the client is running, then deploy them to the
client's
system.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP



"Terry" <Terry@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0755605F-D38F-40B6-BEB9-5C2851335F27@xxxxxxxxxxxxxxxx
I feel silly asking, but I'm a beginner. I have access to all MS SQL
Servers,
the express, workgroup, standard, developer, and the enterprise
version,
both
2005 and 2008.

My question is, which one should I install for creating client
websites.
There are so many different version out there. For example, if I
have
one
client that uses sql 2005 standard, one with sql 2008 enterprise, am
I
suppose to install them all. Goodness??? Can't the higher version,
like
sql
2008 enterprise build a database for 2005 workgroup, as an
example???




.

Relevant Pages

  • Available List of my consultants from Infovision Technologies.
    ... consultants for Oracle Developer and SQL ... Skill: Oracle Pl/SQL Developer, ... repetitive database processes in UNIX ... Snapshot and Merge in SQL Server 2000 and SQL Server 2005 ...
    (rec.sport.football.college)
  • Re: Create SQL cluster on 2003
    ... Since you are in a cluster configuration, ... Microsoft SQL Server MVP ... We only about about 20 databases - all ... Move Databases Between Computers That Are Running SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: Help!! Trying to migrate data from one SQL to another?!?
    ... I came up to the window on the DTS Wizard which has the option to ... I can defend myself on PL/SQL but I am not much of a SQL Server ... The application performs a replication between databases but due to ...
    (microsoft.public.sqlserver.dts)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... "In some cases, you may want to copy the system databases, including the ... from the source SQL Server 2000 instance to the SQL ... System Databases" in SQL Server 2005 Books Online to see how to do this" ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... Microsoft SQL Server MVP ... MVP - Windows Server - Clustering ... from the source SQL Server 2000 instance to the SQL ... > 2005 instance before transferring user databases. ...
    (microsoft.public.sqlserver.clustering)