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

CORRECTION!!!!

You cannot attach (or move or backup/restore) a SQL 2008 database to a SQL 2005 server regardless of edition.

END CORRECTION!!!

When you develop a database in a specific version (2000, 2005, 2008) of SQL Server, you can "move" that database to a new host within that version, even if the edition (express, developer, standard, workgroup, enterprise) is different. There are a vew restrictions, but for the most part that is how it works.

Enterprise is generally used for large-scale systems. SQL Express is the intended back-end for small single-server web sites.

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



"VeganMan" <VeganMan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message 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

  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: BizTalk Server 2004 ConfigFramework.exe error
    ... one BizTalk is installed on? ... machines (both for SQL and DTC) is not blocked by firewalls and new MSDTC ... Multi-computer configuration using Windows Server 2003 or Windows XP ... >>all associated databases. ...
    (microsoft.public.biztalk.general)
  • RE: Clustering a standalone SQL server + storage array
    ... working as expected with out error your ready to install sql server. ... log files to the data and log shared drives you setup as part of the cluster. ... Our apps team look after a trading system that uses an HP DL360 server ... running SQL 2000 SP3a with a few small databases on it. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including the ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2005 servers with multiple instances
    ... Microsoft SQL Server MVP ... given the same number of user databases. ... we've decided to use SQL 2005. ... SQL 2005 clustering? ...
    (microsoft.public.sqlserver.setup)
Loading