Advantages and Disadvantages of SQL EXPRESS

Question

Post reply

Advantages and Disadvantages of SQL EXPRESS

Joy Smith San

SSC-Insane

Points: 24877
More actions
December 21, 2008 at 11:35 pm

#195361

Dear All,
One of our client is planning to use SQLSERVER express as they dont want to pay for database.
Can anyone tell me what are the advantages and disadvantages of SQL EXPRESS please.
Thanks in advance.
Santhu

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

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

Johan Bijnens SSC Guru Points: 135376 More actions · Answer 1

SQL2005 : http://www.microsoft.com/Sqlserver/2005/en/us/Compare-Features.aspx

SQL2008: http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Suresh B. SSC-Insane Points: 22986 More actions · Answer 2

Can anyone tell me what are the advantages and disadvantages of SQL EXPRESS please.

1. Database size cannot be more than 4 GB

2. More than 1 CPU is not used

3. More than 1 GB RAM is not used.

4. No SQL Agent

Joy Smith San SSC-Insane Points: 24877 More actions · Answer 3

Joy Smith San

SSC-Insane

Points: 24877

December 27, 2008 at 2:41 am

#917992

Thank you somuch

Chris Harshman SSC-Forever Points: 42192 More actions · Answer 4

nairsanthu1977 (12/21/2008)
...client is planning to use SQLSERVER express as they dont want to pay for database.
Can anyone tell me what are the advantages and disadvantages of SQL EXPRESS please.

I suppose it depends on their needs. If they require SQL Server for a specific reason such as a third party application requires it, or they need replication, etc, then they will have to deal with the limmitations posted by other people. If they don't specifically need SQL Server, are just doing basic CRUD operations, and don't want to live with the 4GB database or 1 GB RAM limitations, then there are some fine open source alternatives out there such as

PostgreSQL: http://www.postgresql.org/

Firebird: http://www.firebirdsql.org/

etc. that run perfectly fine on a Windows server.

Suresh B. SSC-Insane Points: 22986 More actions · Answer 5

The advantage of SQL Express is scaleability.

Later you can upgrade it easily to standard/enterprise edition and take advantage of features like Replication, Mirroring, Log Shipping, Clustering, Database Partioning, SSIS, SSRS, SSAS.