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

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: Enterprise Manager Tools
    ... Steve; ... we have customers that we sell, create and maintain SQL ... enterprise databases. ...
    (microsoft.public.sqlserver.msde)
  • Re: Dont understand what version of SQL to install
    ... because SQL Server 2008 Enterprise Edition can be installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: Dont understand what version of SQL to install
    ... Can I use SQL Developer 2008 to create 2005 databases on different versions ... You cannot attach a SQL 2008 database to a SQL ... installed on Client OSs such as Windows Vista. ...
    (microsoft.public.sqlserver.setup)
  • Re: BizTalk eating up SQL Server (Virii Behaviour)
    ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
    (microsoft.public.biztalk.general)
  • 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)
Loading