How to create setup file to install C# app with database in Inno Setup

Question

0.00/5 (No votes)

See more:

I need to install C# windows service with database.

I need to create installer like that:

1. check if there is SQL Server 2008
2. if can't find SQL Server - than ask client to choose the path or leave.
3. check if there is .NET Framework 4.0
4. Eventually install .NET Framework 4.0 - if it's missing

5. Connect and log into SQL Server,
6. Create tables, procs etc (run sql scripts)..

7. Install windows service from cmd line. In this point I also have to setup the connectionstring in my app.config - is that possible?)

I thought, Inno Setup will be good tool - but now I don't know if it's possible with that tool?

Could you help me, how to do that? Specially with that database. I have no idea how to connect to sql server and create database with tables, from Inno setup for example. Please help.

Posted 28-Jul-11 10:29am

mnd017

Updated 28-Jul-11 12:45pm

v2

Add a Solution

1 solution

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)

Christian Graus · Answer 1 · 2011-07-28T15:09:00

I've never used Inno setup, but I've never seen a setup program that can do that. Requiring .NET 4 is easy. SQL Server is a commercial product, so you're better off, as the user has to set up a connection string anyhow, just asking the user for that and/or checking if SQL Server appears to be present as part of the initial first run of the program. This also allows a user to finish installing your program first, then install SQL Server. How do you install the DB to SQL Server ? I'd run scripts from inside your program, this also allows the user to do that to reset the DB, or set up a new one.