MS-SQL Sever Version Question

[gmhanna]

Hi, I've recently upgraded to VS2010 which includes SQL Sever Express. I also have access to every version of SQL Sever, but I'm not sure which version I should be running so let me explain what I'm doing. I would like to develop applications that use SQL Server as the database engine and distribute these as commercially available. The applications are simple applications such as a Recipe Manager which also may hook into an food inventory manager. So I don't need something with lots of bells and whistles. I'm also going to develop some SQL Web Applications, which may use a few databases as well. I have an IIS Web Server on another machine. Here's what I'm thinking but I could be totally off base. On my development machine, I would run either SQL Express or SQL Developer, not sure which is the right choice here. Is setting up SQL Developer more complex than SQL Express? Also, does SQL Developer let you distribute SQL Express with the installer of your application? On my Webserver, I was thinking of running either SQL Web, or SQL Enterprise, I'm not sure of the right choice here. Also, is one version more difficult to setup and configure than another? Thank you for your input...

Glenn

[Corporal Agarn]

Setup is similar for any version. Since Express is free so I would suggest using that, with the the end user having the option to connect to other SQL servers. Also if you program using a different version than you plan to distribute you will have problems. We currently use 2008 for development and 2000 for production (working on upgrading), this has caused some problems. As to distribution I cannot help you.

[Andy_L_J]

You can distribute SQL Express with your Application - the distribution licence is free. I suggest developing with the tool the user will be using (or that your app wil be using) - SQL Express. SQL Developer is a Full Enteprise version with user license restrictions I believe - 1 Developer, you will still have to Deploy your databases to another Production Server with the appropriate licensing.( I use SQL 2008 Standard as I don't need the Mirroring and some other stuff available in the Enterprise version).

I don't speak Idiot - please talk slowly and clearly 'This space for rent' Driven to the arms of Heineken by the wife