Click here to Skip to main content
16,016,306 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear Friendds,


Here i have Developed One Windows Application.But i want to install this windows application in Multiple Systems.Database should be in One System.So what is the Process How to install.So please Give Me required Suggestions.
My application is Developed on vs2008 coding in c# back end sqlserver.



Regards,

Anilkumar.D
Posted
Updated 30-Sep-11 0:18am
v2

1 solution

Create a new project in your solution: make it a "Setup and Deployment" project, and follow the instructions. It will create a setup program which will install your application.

SQL is trickier:
You should not include SQL Server in your installation. There are a couple of reasons:
0) You can only distribute SQL Server Express for copyright reasons - not SQL Server full version.
1) They may already have SQL Server installed on the network. If so, then they will presumably want to use that version.
2) If they do have SQL server installed and you start proliferating SQL server Express instances, you are going to annoy the heck out of the database administrator...
3) A single site installation of SQl Server is a lot more likely to be backed up than a number of scattered version under user control.
4) Sql server is quite complex for a "normal" user to install and administer - it is not a good idea!
5) It will destroy the primary advantage of using Sql Server over SqlCE or SQLite - multiuser access. If everyone installs their own copy of SQL server, then you will have multiple copies of your database, each used by a single person. This will cause some confusion, and (depending on how you wrote the original database) may take some considerable effort to combine into a single instance when the problem is realized.

Instead, inform the user that it needs SQL server, and provide a link to the Express version in case they do not have it.
 
Share this answer
 
Comments
Anil Honey 206 30-Sep-11 7:09am    
Thanks for Your Suggestion.So if i develop exe file for my windows application.I will install that Exe in my 4 pcs.So aboutt my database i will hold in another Pc.So how can i Use this appliaction in 4 Pcs.What about the Connection String.I should Deploy application in LAN?
OriginalGriff 30-Sep-11 7:30am    
If they have SQL server installed, the connection string will be the same for all four PCs: it specifies the server instance by name and then the database name.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900