tags:

views:

25

answers:

1
+1  Q: 

How do I upgrade a database using WIX?

I have a Visual Studio 2010 database project and a WIX installer. What is the best way to go about installing that database to a server using that WIX installer? How would I set that up?

I'm having a hard time with WIX as it is, so hopefully somebody has some insight into how to deal with this.

A: 

It's not so difficult at all. First you need to have the DB script file and then use the WiX SqlExtension. The next tutorial will help on your purpose.

WiX tutorial: Lesson 7 SQL

Mario  2010-07-21 01:34:50

related questions

Visual Studio 2010 Database Projects: Are there any videos/tutorials or comments about the new Database Project Types?
Visual Studio 2010 Database Project does not understand Schema Names anymore?
VS 2010 Database Project Run Script Conditionally
What happened to the "Run" and "Run On" commands in Visual Studio 2010 Database Projects?
How do you actually use Visual Studio Team System database projects to version Sql Server
SQL Database Project in Visual Studio
Nontrivial incremental change deployment with Visual Studio database projects
Visual Studio For Database Professionals 2008
How to force VS2008 to "Generate Create Script to Project" to multiple files when multiple stored procedures are selected?
Using MS Team System 2008 Database Edition
Visual Studio 2008 Database project Deployment Baseline
Unable to Load Database project in VS2008
database project takes a long time to open
Timestamps during MS Build
Syncing permissions between a Database project and a database using Visual studio
Pre-Deployment in Database project
Duplicate Schema
Post build on database project
Executing scripts from a database project in visual studio
Do I need the .dat file when I place a visual studio database project under version-control
How to programmatically navigate the Schema View in Visual Studio 2008?
Anyone using "database projects" in Visual Studio?
Where is the handy designer for setting Permissions and schema diagram designer in a SQL2005 Database Project in VSTS2008 Database Edition GDR RTM?
"Show All Files" option missing in VS Database Project
How do you resolve Linked server references in SQL Database project in VS?