SQL Server 2005 express in production server

Question

Post reply

SQL Server 2005 express in production server

Marvin Perez

SSC Enthusiast

Points: 115
More actions
November 29, 2005 at 7:13 pm

#167187

Hi,
My question is simple. Can i use SQL Server 2005 in production server? I know theres a lot of limitation in express edition but i want to use it as a database engine for the meantime untill we purchase the enterprise edition.I want to do this so that during my development i am already using 2005 version.
thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Joseph Mulhall SSCarpal Tunnel Points: 4672 More actions · Answer 1

If it meets your requirements* then yes. You can later upgrade to Enterprise.

*Feel free to post up what these are.

Marvin Perez SSC Enthusiast Points: 115 More actions · Answer 2

Thanks...

As of now, my requirements are just for data storage and stored procdedures.I know sql 2000 is fine. But i want to experience the power combination of visual studion 2005 and sql server 2005 while developing my applications. So if time comes and we are ready to purchase enterprise edition, adjustment is not that big i think.

Licensing issue is just the hindrance why we cant purchase it now. I feel our accredited supplier in our company give us the wrong information about this.

List of limitation of sql express is my second target to know. I dont have time as of now to read the documentation. I still preferred to ask from the experts like you guys..

Thanks and more power to sql server 2005.

Joseph Mulhall SSCarpal Tunnel Points: 4672 More actions · Answer 3

It's pretty simply laid out here:

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

If I were you though, I wouldn't even consider it. Put it on your dev environment and copy the db across, get it working, periodicall capture workloads from your live environment* with profiler to test against your 2005 version.

A production environment should be treated as untouchable unless you are a) fixing something or b) updating a feature.

*Unless this is sensitive data of course

Marvin Perez SSC Enthusiast Points: 115 More actions · Answer 4

Yes exactly, im not doing anything on my production server. Actually what i want to know if its legal to use sql server 2005 express edition in production server as per microsoft licensing/terms and condition is concerned. And based on my understanding in your first post yes it can be used.

Thanks.