Bilal Zia
Bilal Zia

Reputation: 41

How to package and deploy a C# desktop application with a SQL Server 2012 database in Visual Studio 2010?

I have created a database application using C# in Visual Studio 2013. It uses SQL Server 2012. I don't know how to package my database in the .msi package for this application. Please help me in writing a script to create the database and setup its connection strings. So that I can install and run the app using SQL Server on any other PC besides my own computer where I am developing the app.

Upvotes: 0

Views: 1141

Answers (1)

Puterdo Borato
Puterdo Borato

Reputation: 388

The way I saw it in a commercial project was:

  1. Create an msi installer for your own application using WiX.
  2. Get the msi package for SQL server installation.
  3. Create custom installer in wix or in a programming language you know. It will use Deployment Tools Foundation to run SQL msi and your app msi.
  4. Pack it all into nsis package so you have a single Installer.exe file as an output.

Also check:

Upvotes: 1

Related Questions