Click here to Skip to main content
Rate this: bad
good
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,
Deepak.
Posted 28-Feb-12 6:33am
Comments
catchbobbie at 29-Feb-12 4:18am
   
Thanks AspDotNetDev, but I do have some Stored Procedures in background.
Rate this: bad
good
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.
  Permalink  
Comments
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 http://www.microsoft.com/sqlserver/en/us/editions/express.aspx
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 - http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

This has the answer
Package and Installation .net[^]
  Permalink  
Comments
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 OriginalGriff 459
1 Maciej Los 404
2 Sergey Alexandrovich Kryukov 192
3 CPallini 185
4 Hard_Rockz 115
0 OriginalGriff 5,634
1 Sergey Alexandrovich Kryukov 4,763
2 Peter Leow 2,954
3 Maciej Los 2,614
4 DamithSL 2,465


Advertise | Privacy | Mobile
Web04 | 2.8.140718.1 | Last Updated 28 Feb 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid