MSSQL Server

[georgepatotk]

Dear all,

 

I am in the plannig stage for a new project. The project is a webbased e-commerce site. I am now confused on what edition of MSSQL to be bought for this project. Anyone can suggest to me on it?

 

Is that sufficient for me to buy a MSSQL standard version with 5 user cal? Please do me this favor. Thanks a lot..

[Nerseus]

I'd call MS to confirm, but I think if you're just doing development, you'd want the developer edition. It might be free, I'm not sure.

 

We use our MSDN Universal license to run SQL Server, which can be used for development at no additional charge.

 

-ner

[georgepatotk]

The server is for business usage. Means to be install in their server.

 

For my own development, I am using MSDE. Sufficient enough.

But for my customer, the version is the most suitable for them? For a e-commerce site?

 

Thanks a lot

[georgepatotk]

Anyone there could help me? I need to clear this doubt urgently.

[Nerseus]

As I said, if you want what's "right", call Microsoft - they have a very large team that does nothing but answer questions on what versions/types/licenses you need for each type of software.

 

If you know 5 users will be the most you'll need (a very small website), then MSDE will likely work. That's 5 current connections, which should generally support 20+ web users at once, depending on the type of web application.

 

Otherwise the client will need to license SQL Server, which can get expensive quickly (based on number of processors I believe).

 

I thought you were initially asking what version/licence YOU need to develop, which is a completely different licensing arangement. Basically, MS doesn't charge for the Development versions of SQL Server. There are exceptions, but the folks at MS can (and should) answer all your questions.

 

-Nerseus

[jvcoach23]

might also ask about using small business edition.. if it fits within the org your working for. With SB you can have SQL server being used for an external web app and it won't cost you near as much. If SB won't fit in.. then it's like they have said above.. you'll have to pay for an internet connection.. which goes by processor. I can't say for certain, but the number $4,000 comes to mind for a 1 processor box.. still have to buy the sql server licenes.. was thinking that was around $1,200 with maintenance.. oh yea.. and the windows 2003 license if it's on a new box....

[georgepatotk]

Ok, thanks. Probably I will call Microsoft and ask for it. Thank you very much.

[DieSkim]

Ok' date=' thanks. Probably I will call Microsoft and ask for it. Thank you very much.[/quote']

 

Hallo,

 

The other package you can use will be MySQL, I had alot of success with that and ASP.Net / VB.Net, you don't have the user license issue, nor that large amount for server software costs.

 

I takes longer to setup and you initial connection code but after that, it is the same you will not know the difference.

 

J.

[georgepatotk]

The reason I don't like MySQL is the installation. if I would like ot distribute my software as package software, I need to install it manually to every customer.