how to deploy visual C# 2010 Based Application which use sql server 2008 to store and retrieve data+?

Question

1.00/5 (1 vote)

See more:

, +

i developed application in visual c# which use sql server 2008 to store and retrieve data when i deploy this application to friend PC.
1)because of absolute link i am getting error to connect to the database
2)i need to install sql server and restore database on that pc
is there any way to automate this like searching database and connect it so that my first problem will solve and also automatically install required sql server component instead of whole installation of sql server.
feel free to asked more specific details if required.

Posted 27-Jun-15 3:58am

Member 11012743

Add a Solution

Comments

[no name] 27-Jun-15 11:23am

Since you are going to repost this over and over....
Read the documentation for whatever you are using to create your install package. That will tell you what you need to do to accomplish this. We can't read your mind either.

F-ES Sitecore 27-Jun-15 13:07pm

SQL Server isn't a distributable component, it's a standalone product. You don't give SQL Server away with your app, the target machine either needs SQL installed or you need your database on a server that the client can attach to. It might be better to use SQL Compact as that is intended to be distributable.

For install makers try Install Shield. If you're only interested in free products then you should mention that in your question, and you'll find suggestions if you google.

Suvendu Shekhar Giri 27-Jun-15 18:34pm

Perfect suggestion :)

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)

adityasahver · Accepted Answer · 2015-06-27T19:55:00

Solution 1

Instead of installing and setting up the entire SQL database in the machine where you are deploying the application, why cant you use the App_Data folder of your solution for the Sql MDF file storage and then use that MDF file for application.
If will not require the SQL server on the machine where you are deploying the Application, though will require the SQL adapters installed.

Posted 27-Jun-15 19:55pm

adityasahver

Comments

Member 11012743 28-Jun-15 2:49am

thanks i will try that

Member 11012743 28-Jun-15 8:52am

adityasahver can you guide me for that what you suggested

adityasahver 28-Jun-15 13:10pm

http://www.codeproject.com/Questions/441590/How-to-add-existing-database-in-app-data-folder-in