Click here to Skip to main content
12,399,299 members (57,963 online)
Rate this:
 
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 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 28-Feb-12 13:17pm
   
Right, 5!
barneyman 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 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 - 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 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.160721.1 | Last Updated 28 Feb 2012
Copyright © CodeProject, 1999-2016
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