c# application without installing MS-SQL Server in client machine

Question

2.36/5 (4 votes)

See more:

, +

I have developed my c# desktop application using MS-SQL server 2008 R2 as back end. I have used windows authentication mode. So is it necessary to install MS-SQL server 2008 R2 in client computer/machine ? or is there any option so that i should not install whole server in client machine. I have searched for it many times and found SQLCE. SQLlite, SQLExpress might be option. Please make me clear about this.
Thank You

Posted 29-May-13 4:48am

Sharan Khanal

Add a Solution

Comments

David_Wimbley 29-May-13 10:56am

Why dont you just leave the database on a server somewhere and have all clients point to that server?

Sharan Khanal 29-May-13 11:01am

What if the application is for single desktop user - not in network?

David_Wimbley 29-May-13 11:18am

You can add SQL Express as a dependency i believe using visual studio setup project

msaroka 29-May-13 11:04am

Have you looked into using LocalDB? You can basically use the SQL engine to a mdb file.

1 solution

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)

OriginalGriff · Accepted Answer · 2013-05-29T05:07:00

If you are using Sql Server in your app, then there must be an Sql Server installation within reach of your application when it runs: that doesn't mean it must be on the same machine - that is generally a poor idea with release software for a variety of reasons - but it must be available, which normally means on the same LAN. This can be Sql Server Express or the full retail version.

If you are only using the database for single user storage, then SQLCE or SQLite are very appropriate and do not require any SQL server installation - in fact they just need a couple of assemblies which should be loaded as part of your deployment anyway. These would require changes to your code (but probably not major changes) and provided you don't want to share the DB data, they are both an excellent way to do it.