Click here to Skip to main content
13,050,429 members (90,797 online)
Rate this:
Please Sign up or sign in to vote.
See more:
Hello All,

I have created a small .Net windows application using VS 2008 and SQL 2008. I now want to create a setup file to give it to users for installation. This is a standalone application which will run on a client machine and database will be residing on the same machine.

How can I create a setup file which can install both, the application and database, in single setup.
Any help/suggestions would be highly appreciated.

Thanks in advance,
Posted 28-Feb-12 6:33am
catchbobbie 29-Feb-12 4:18am
Thanks AspDotNetDev, but I do have some Stored Procedures in background.
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

To deploy SQL Server with each install of the application is probably going to be prohibitively expensive (thousands per install). Instead, I'd use SQL Server CE, which is is smaller version of SQL Server that is built into .Net. It is very similar to the full SQL Server, but doesn't have some things like stored procedures and native support by Entity Framework.
thatraja 28-Feb-12 13:17pm
Right, 5!
barneyman 28-Feb-12 22:20pm
CE is a bit limited ... there is free 'full' SQL
AspDotNetDev 29-Feb-12 0:10am
I forget, are there any licensing limitations on using that in a production environment?
barneyman 29-Feb-12 0:19am
10Gb max DB, 1Gb RAM used, 1CPU, no concurrency limit -
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

This has the answer
Package and Installation .net[^]
Espen Harlinn 28-Feb-12 14:24pm
Nice link :)

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 28 Feb 2012
Copyright © CodeProject, 1999-2017
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