create setup application c# with sql database ?

Question

0.00/5 (No votes)

See more:

hi
i create windows application using c# code , connected to sql server database ,
how can i create setup file included my windows application and database inside it ?
please help me ,,,,,
i need easy way to do my package :)

Posted 12-Apr-15 9:12am

sam9787

Add a Solution

Comments

Florian Braun 12-Apr-15 15:34pm

a good way is using wix. There should be good tutorial on this page here
like http://www.codeproject.com/Articles/331368/WIXDataBase

Style-7 13-Apr-15 2:15am

Inno Setup

2 solutions

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)

shA.t · Answer 1 · 2015-04-12T21:51:00

In most Installers like instalshield you can run a batch file after finishing install process. I suggest you to create a Default Database Backup file and restore it by that batch file.

Default Database Backup:
Is a backup file that you make from your Database when your tables are empty or have hard-coded or default data.

Make a Restore Batch-File:
Make a new Text-file and change its extension to `bat` then use `sqlcmd` command to restore your Database like this:

sqlcmd -S %DB_HOST% -Q "<your restore="" query="">"</your>

And a restore query like this:

SQL

RESTORE DATABASE %DB_NAME% FROM DISK = '%BACKUP_FILE%' WITH REPLACE;

Or for a better query follow this question

Add your Backup file and Batch-file to your setup:
When you are making your setup, add the Backup file and Batch-file in it that those will add in the destination path.

Change your setup settings to run Batch-file at the end of setup>

Abhinav S · Answer 2 · 2015-04-12T22:31:00

Solution 2

Try these links -
Deploy SQL Server databases easily with an Installer class[^]
.NET Installer that Automatically Installs SQL 2005 Express[^]
Deploy your Application and Database[^]

Posted 12-Apr-15 22:31pm

Abhinav S