Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

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
0
Nigel Keith-Walker
Asked:
Nigel Keith-Walker
  • 4
  • 4
2 Solutions
 
ICaldwellCommented:
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
0
 
ICaldwellCommented:
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....
0
 
Nigel Keith-WalkerAuthor Commented:
I have downloaded the SQL 2008 Express.  But I think that this only a 180 day trial.  Should this be a priority?
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

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

http://en.wikipedia.org/wiki/SQL_Server_Express
0
 
Nigel Keith-WalkerAuthor 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.
0
 
ICaldwellCommented:
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...
0
 
Nigel Keith-WalkerAuthor 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.
0
 
angus_young_acdcCommented:
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.
0
 
Nigel Keith-WalkerAuthor 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.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now