SQL Server Standard or Workgroup?

[txmed]

I am looking to purchase SQL Server 2005 for a new project I am working on. When this project is finished, I will be able to deploy the application to numerous companies, either using SQL Server 2000 or 2005.

Can someone please tell me the difference between SQL Server 2005 Workgroup and Standard? I realy don't want to spend the extra money on the Standard Edition when the Workgroup would work just a good.

By the way, one of my new development machines is Windows Vista. I can't use SQL Server 2000 on it because it is not supported.

Thanks in advance for any help.

(txmed)

 

[gmmastros]

How will you be distributing your database? If you develop on SQL 2005, you cannot simply attach this to sql 2000 and expect it to work. Since you want to support sql 2000, then I recommend you use that to develop with. That way you will not accidentally use a 2005 feature.

If this is for development, then I recommend you get the developer version. The price is very cheap. Also... eventhough microsoft doesn't support 2000 on vista, it will probably work, so it may be worth it to try. I don't have a vista machine to test it on.


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[gmmastros]

A quick google search...

http://www.amazon.com/Microsoft-SQL-Server-Developer-2005/dp/B000BHQ5JW

Looks like it's about $42.00 (US).



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[txmed]

gmmastros,

I will not be distributing my database. What I will be doing (and what has work for me in the past) is that I will create a app that will build all of the database tables, views, and stored procedures onto their instance of SQL Server, whether it be 2000 or 2005. I will only be using functions/procedures that are supported by both versions.

I may try getting 2000 to work with my Vista machine, but I really start migrating my work over to 2005.

Also, thanks for the link to the Developer Edition. I wasn't aware this version existed. I was thinking about using SQL Server 2005 Express Edition, but I would much rather use the Developer edition.

(txmed)

 

[mrdenny]

This URL shows the differences between all the editions.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[txmed]

mrdenny,

Thanks for sending me this link. Yesterday as I was doing my research I came about this link as well. However, the first couple of times I looked at this comparision chart I failed to read this paragraph:

SQL Server 2005 Developer Edition and Evaluation Edition are not listed in the tables. These editions have the same feature set as the Enterprise Edition; the only difference between these editions is the licensing policies.

Once I finally read this I was sure that the Developer Edition is what I needed.

Thanks again for your help!

(txmed)