local database (.sdf) or service-based database (.mdf)?

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

VS2008

, +

Hi, i have just a simple question..
What is the main difference between this two types, and which one is preferred? (or both has its own benefits..?)

Also, if i use any of this two, what would i need to install to the customer computer, beside .net framework 3.5 so my program would work...

Thanks in forward..

Posted 13-Feb-12 3:49am

Xonfused

Add a Solution

Comments

Zeeshan-Ali89 13-Feb-12 9:58am

same question here?

2 solutions

Solution 1

This[^] is how to find information on the internet.

Posted 13-Feb-12 6:15am

Christian Graus

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sandeepgh · Accepted Answer · 2013-07-11T03:35:00

I would rephrase your question as when should you use SQL Server Compact (Embedded editon) vs SQL Server Express etc.

SQL Server Compact 4.0
Individual Database file size is limited to 4 GB.
Run in-process (Embedded) with an application.
No FileStream support
Limited to 256 concurrent connection.

SQL Express 2008 R2

Individual Database File size is limited to 10 GB
Excluding user instance scenario it can be used as a standalone database
Filestream and CLR Support.
No limit on number of simultaneous connection.

Also, SQL Server Compact has certain T-SQL related limitation, MSDN has detail comparision

Usage:

SQL Server Compact edition it targeted to be used for mobile phones, PDA's,
Tablet PCs and Desktop applications.

SQL Server Express edition can be used for both Web (Limited to 1 GB of RAM and Single CPU) and Windows Desktop applications. Latest edition of SQL express individual database file is limited to 10 GB.