Click here to Skip to main content
15,891,657 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
In My C# Window Application I Have Used SQL Databased…
So It’s Possible When I Create My C# window application Setup File( means Published my Application ) at time SQL SERVER and My SQL Database are include in setup File…
So when I install my application in Clint PC At That time also install SQL server and My Database.
If is Not Possible Then Tell me Best way How to Make Setup File of My Application and How To add SQL Server And My SQL Database in Client PC..
so I will install my application in client PC .
And I can Start my Application
Posted

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.
 
Share this answer
 
You can do that using set up and deployment projects. Check it out on MSDN.
 
Share this answer
 
On the File menu, point to Add, then click New Project.

In the resulting Add New Project dialog box, in the Project Types pane, open the Other Project Types node, open Setup and Deployment Projects, and select Visual Studio Installer.

In the Templates pane, choose the type of deployment project you want to create. For more information, see Setup and Deployment Projects.

To add an existing deployment project to a solution

On the File menu, point to Add, then click Existing Project.

In the resulting Add Existing Project dialog box, browse to the location of the deployment project and click Open.
 
Share this answer
 

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