Which version Visual Studio

I have Visual Studio Tools version 2003
It includes
MS SQL Server 2000 Developer Edition
MS Visual Basic .Net standard 2003
MS Office Access 2003 with Access runtime

I want all of these and
MS SQL 2008 developer
Support for XML schemas with SQL 2008

Which edition do I need?
1 express edition
2 Upgrade to standard 2008
3 Full copy of standard
4 Upgrade to Professional
5 Full Professional
Nigel Keith-WalkerContractorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Express would be enough but I think you will find it harder to use since a lot of the features are disabled... I would upgrade to standard 2008 or professional if you can afford it...

You will also need to buy MS SQL 2008 developer separate from Visual Studio....

Here is the comparison guide:  http://www.microsoft.com/downloads/details.aspx?familyid=727BCFB0-B575-47AB-9FD8-4EE067BB3A37
Also remember VS 2010 is in Beta right now: http://www.microsoft.com/visualstudio/en-us/products/2010/default.mspx

May want to wait for it....
Nigel Keith-WalkerContractorAuthor Commented:
I have downloaded the SQL 2008 Express.  But I think that this only a 180 day trial.  Should this be a priority?
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

The full version of SQL 2008 is a trail 180 days.... The Express version is free, although it does have limitations noted here:

Nigel Keith-WalkerContractorAuthor Commented:
It seems that the developer version of SQL2008 is only $US50.  Though I have bounced off the customer the possibility of a SQL 2008 production licence being in the $US1,500 range.
I am tempted to go for the Beta version of Visual Basic 2010 with the intention to upgrade later.  Still wondr if the SQL XML features are only available in the Professional.
Yes Developer edition is cheep because it is only suppose to be used for development, not for production...  Not sure exactly what XML features you want but they should be available in Standard...  However I am not sure if they will require you to get professional when 2010 comes out, how to wait for that comparison guide...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Nigel Keith-WalkerContractorAuthor Commented:
Hi - Yes I would only use the Developer SQL2008 to develop the system.  The user will have to bear the cost of software required to run the system.  I had hoped to develop a syatem that would extract an XML in the format of the Govt agency specified schema.  Now I will settle for anything that will allow me to conform to their specs.
As for the Visual studio. I am tempted by the Visual studio 2010 Beta to be released late March.  But suspect that I would not be able to upgrade from standard or from the 2003 Visual studio tools.
I would stay away from VS2010 until it is actually released, remember that it may still have plenty of bugs, and if you developed your project using it then you may have issues if you wish to go back to a more stable version like 2008.
Nigel Keith-WalkerContractorAuthor Commented:
It will probably be months before I have assimilated sufficient information to know if this was right.  But it helped me make a decision.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.