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

I just purchased Visual Studio 2008 Professional with the Premiun MSDN
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.

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

It depends on what newsreader you use. It seems you use "X-Newsreader: Microsoft CDO for Windows 2000", I don't know about it, sorry.

--
Ekrem Önsoy - SQL Server MVP



"VeganMan" <VeganMan@xxxxxxxxxxxxxxxxxxxxxxxxx>, iletisinde şunu yazdı, news:477704EA-CE7B-48BF-AA50-194BD6CFECFF@xxxxxxxxxxxxxxxx
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
Quantcast