Deploy SQL database with .Net windows application.

Question

0.00/5 (No votes)

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,
Deepak.

Posted 28-Feb-12 6:33am

catchbobbie

Add a Solution

Comments

catchbobbie 29-Feb-12 4:18am

Thanks AspDotNetDev, but I do have some Stored Procedures in background.

2 solutions

Solution 2

This has the answer
Package and Installation .net[^]

Posted 28-Feb-12 7:16am

thatraja

Comments

Espen Harlinn 28-Feb-12 14:24pm

Nice link :)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

AspDotNetDev · Accepted Answer · 2012-02-28T06:49:00

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.

Posted 28-Feb-12 6:49am

AspDotNetDev

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