database in application folder

Question

1.00/5 (2 votes)

See more:

Hi All,

I want my database to be in application folder so that it becomes portable i.e it could run on any computer without restoring the database to all computer. is it possible with SQL database if so what would be the code to connect to it.

complete this statement :

sqlconnection con= new sqlconnection ("

Posted 5-Jul-11 2:03am

Member 8043849

Updated 24-May-17 4:29am

Ramalinga Koushik

v2

Add a Solution

3 solutions

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)

Abhinav S · Answer 1 · 2011-07-05T02:06:00

Solution 1

If you use SQL Server, you will be setting up the DB on a server.
As a result, it will be accessible to all users who have privileges to access the DB (and machine)

Moving the DB around is not recommended as your db is expected to grow and become less and less portable.

For a connection string, try http://www.connectionstrings.com/[^].

Posted 5-Jul-11 2:06am

Abhinav S

Comments

fjdiewornncalwe 5-Jul-11 8:13am

You've covered it all. +5.

Abhinav S 5-Jul-11 8:13am

Thank you.

Member 8043849 5-Jul-11 8:24am

no its not covered .. plz help

suppose i have a simple application that uses a database . and i want to run it on another computer then what should i do....

Member 8043849 5-Jul-11 8:24am

no its not covered .. plz help

suppose i have a simple application that uses a database . and i want to run it on another computer then what should i do....

cicciocrazy · Answer 2 · 2011-07-05T02:30:00

If you want a portable application, you must use a "portable" database.
There are more solutions to do it, for example: SqLite, Sql Server Compact Edition, Xml ,etc.

Remember:
If you want to use a RDBMS, you must install the correct database engine and make sure that the DB dll are copied in the output folder, otherwise if you choose a xml database you do not need a db engine.

#realJSOP · Answer 3 · 2011-07-05T02:45:00

Solution 3

The problem is Windows. Vista and Windows 7 do not allow you to put data files into any subfolder inside the Program Files folder. It forces you to use the "special" user data folders. This is a security issue. You can, however, create a script that you can run on the database server that will create all of the tables, stored procedures, functions, triggers, and views when your app is installed.

Posted 5-Jul-11 2:45am

#realJSOP

Comments

cicciocrazy 5-Jul-11 8:55am

That is for a traditional installation. But if the program must be Portable, i suppose that It run from an external disk.
So there are no problems.

Member 8043849 5-Jul-11 9:06am

ya u r right i mean it to run from removable disk ( pen drive )