difference between database

Question

0.00/5 (No votes)

See more:

plz tell me what is the difference between local database and server database.
Actually in my previous project i have created database on sql server2005 and but now i need to create local database.I also want to know what is local database(.sdf) and service based database(.mdf)

Posted 5-Apr-12 19:29pm

Member 8233601

Add a Solution

4 solutions

Solution 4

Local data base:

contain information in your local machine.

Server data base;
u can access through your machine.but data contain in commom location (server)

Posted 5-Apr-12 19:58pm

Arul R Ece

v2

Comments

Member 8233601 6-Apr-12 2:23am

how do i create connection with local database(.sdf),i mean connection string

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)

Maheshdotnet2010 · Accepted Answer · 2012-04-05T19:36:00

A service-based database is a database that is only accessed through a server. It uses an MDF data file, which is SQL Server format. To be able to connect to a SQL Server database the SQL Server service must be running, because it's that that processes your requests and access the data file.

A local database is one that is local to your application only. It uses an SDF data file, which is SQL Server CE (Compact Edition) format. There is no need to install a server to access an SDF database. You simply distribute the DLLs that constitute SSCE along with your app and access the data file directly.

You'd normally only use SSCE if the data was to be accessed by your app only and there was a relatively small amount of data. For your project you would use SQL Server. For testing purposes you can use the free Express Edition. When deployed you might still use SSEE or you might use a full version of SQL Server. Note that Microsoft include SSEE with their own RMS POS software. SSEE is limited to databases of 4GB though, so even if you start out with SSEE and it can handle the load, you may still have to upgrade at some point in the future based on data capacity.

P.Salini · Accepted Answer · 2012-04-05T19:36:00

SDF files are for SQL Server Compact Edition (SQL CE or SQL Mobile in past),

MDF file is for SQL Server Express or higher editions (Regular SQL Server)

Compact Edition is a compact database for embedding in mobile and desktop applications. I would use SQL express for desktop application since it offers more features and upto 10 GB of data storage per dataabse.

The following white paper provides an excellent comparision between both of them, again which one to choose depends on your requirements.

http://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact_Express_Comparison.[^]

uspatel · Accepted Answer · 2012-04-05T19:42:00

In case of Remote database Clients do not need to install SQL instance on machine. You can create a connection with remote server.and make connection string like

C#

Data Source=10.0.0.28;Initial Catalog=omxintranet_DEV;Integrated Security=true

In case of local database ,You need to install SQL Server instance on client Machine.and use that instance to create connection string.

Quote:
what is local database(.sdf) and service based database(.mdf)

.SDF file is for SQL Server Compact edition while .MDF is for SQL Server database engine data file.

See
SQL Express .VS. Compact edition

difference between database

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0