How can I build a setup in C# with SQL Server included

Question

I created an application using Visual Studio 2010 using SQL Server 2008. How can I build a setup file?

Is it any need of installing SQL Server on another PC to execute my application?

here is an example tu make setup with database: social.msdn.microsoft.com/Forums/en-US/… — Arash
– Arash, Commented Jan 25, 2014 at 8:06

marc_s · Accepted Answer · 2014-01-25 09:42:04Z

2

Question 1: How can I build a setup file?

If you want to build a setup file you need to create a project of Enable InstallShield Limited Version from Setup and Deployment category (in Visual Studio 2012 IDE)

Follow the steps from this link:

How to create Setup file

Question 2: is it any need of installing SQL Server on another PC to execute my application?

If you are maintaining any server machine for maintaining your database then you do not need to install SQL Server on client PC's as you can always refer to the DB-Server machine by just providing DB-Server hostname/IP address in the ConnectionString as below:

String connectionString="Data Source=MyDBServerHostName;Initial Catalog=myDBName;UID=myUserID;password=myPassword;Integrated Security=True;"

If you don't have any server to maintain database, then you need to install SQL Server on client PC.

edited Jan 25, 2014 at 9:42

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Jan 25, 2014 at 8:03

Sudhakar Tillapudi

26.3k5 gold badges43 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Pantelis Natsiavas Over a year ago

@user3234578 Adding an alternative, you could always build your application on a file based database

Collectives™ on Stack Overflow

How can I build a setup in C# with SQL Server included

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related