Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL .NET
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 7:33am
catchbobbie at 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 at 28-Feb-12 13:17pm
Right, 5!
barneyman at 28-Feb-12 22:20pm
CE is a bit limited ... there is free 'full' SQL
AspDotNetDev at 29-Feb-12 0:10am
I forget, are there any licensing limitations on using that in a production environment?
barneyman at 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 at 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
0 Sergey Alexandrovich Kryukov 345
1 OriginalGriff 210
2 DamithSL 210
3 Kornfeld Eliyahu Peter 210
4 Peter Leow 95
0 OriginalGriff 7,315
1 DamithSL 5,199
2 Sergey Alexandrovich Kryukov 4,917
3 Maciej Los 4,866
4 Kornfeld Eliyahu Peter 4,514

Advertise | Privacy | Mobile
Web03 | 2.8.141223.1 | Last Updated 28 Feb 2012
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