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

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: 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
    ... but "moving" a database implies a degree of automation. ... Principal SQL Infrastructure Consultant ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Dont understand what version of SQL to install
    ... Subscription and I still have to pay $49 to use SQL Developer? ... it's not stated that SQL Server 2008 Enterprise Edition can be ... between databases which are created in Standard Edition or Express Edition ...
    (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: DataSet.GetChanges() in RowChanged(DataRowAction.Add)
    ... have you considered SQL Express and use ... > I realize now that I didn't describe well how the client application is ... > Framework installed on the client machine, but not any SQL Server). ... > 20 tables in different relations with eachother in the database, ...
    (microsoft.public.dotnet.framework.adonet)
Quantcast