deployment of my application

Question

0.00/5 (No votes)

See more:

hello

I am using visual studio 2008 and sql server 2005 My application is a winform.

I have my application works fine on my PC that I develop.

I want to install my application in server to be used anywhere in the world (more users will use to connect to the server).

1 - how I have to copy my database on the server??
2-how do I change the database path in the App.config file
this my file:

C#

connectionString = "Data Source = KAHINA-PC \ SQLEXPRESS; Initial Catalog = WORK; Integrated Security = True"
providerName = "System.Data.SqlClient" />
br mode="hold" />br mode="hold" />

3-how I create the executable file??
I'm stuck if anyone can help me please

thanks

Posted 13-Sep-12 23:55pm

kahina_france

Updated 13-Sep-12 23:56pm

CPallini

v2

Add a Solution

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)

Steve Maier · Answer 1 · 2012-09-14T07:37:00

1. For moving the database to the server, it depends on how much control you have. You could just use Attach[^] or you might have to generate SQL scripts to copy the schema and the data to the new database.

2. for the connection string you will have to change the data source to point to the server and SQL instance name. On the internet, this could even just be an ip address. You will also have to remove the Integrated Security because that is for a Windows account to access the database. You should probably create a user in the database and use that as the UserName and Password in the connection string.

3. You are already compiling an exe on your desktop. You can use that. You might actually mean how do you make the installer for the app so that others can put it on their machines. If this is what you really meant then you could make a visual studio installer project and put trhe output of your main project into it. Other installers that you could use are NSIS[^], WiX[^], InstallShield[^], or many other ones.

Hope this helps.