Making setup along with database

Question

0.00/5 (No votes)

See more:

I have developed one software in C#. Now I am creating setup project and add all the Prerequisites that are needed in project.

Now i want that setup will install the database along with setup.

It will check that database is exists or not.

If database is not exists then it will create the database and insert the data along with setup.

IF database is exists then it will just installed my developed software and skipped the database portion.

so it can be achieve or not ?

I am using VS installer to create setup

Database : SQL Server express database

What I have tried:

found that using DbUp can be do but never tried

Posted 18-Nov-21 1:36am

Devendra Sarang

Updated 18-Nov-21 5:21am

PIEBALDconsult

v2

Add a Solution

Comments

PIEBALDconsult 18-Nov-21 8:25am

I recommend not trying to do that. You can specify that the user needs to provide an SQL Server instance, but do not attempt to install one for him. Allow the user to install the database (full or express) he chooses, where he chooses. The user may already have a full SQL Server instance on another system he wants to use to host the database.
Trying to install what the user doesn't want will only cause you both trouble.

Devendra Sarang 18-Nov-21 9:57am

my concern is not sql server instance. My concern is it should install database

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)

OriginalGriff · Answer 1 · 2021-11-18T05:21:00

Solution 1

It's pretty easy to check:

SQL

IF NOT EXISTS (SELECT Name 
               FROM master.dbo.databases 
               WHERE Name = 'MYTestDatabaseName')

Posted 18-Nov-21 5:21am

OriginalGriff