Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# Windows setup
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 9-Aug-11 1:13am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

You can do that using set up and deployment projects. Check it out on MSDN.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

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.
  Permalink  

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

  Print Answers RSS
0 Maciej Los 290
1 OriginalGriff 275
2 Sergey Alexandrovich Kryukov 195
3 BillWoodruff 140
4 ProgramFOX 140
0 OriginalGriff 6,524
1 Sergey Alexandrovich Kryukov 6,048
2 DamithSL 5,218
3 Manas Bhardwaj 4,657
4 Maciej Los 4,150


Advertise | Privacy | Mobile
Web03 | 2.8.1411022.1 | Last Updated 8 Sep 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100