To drop a database on uninstall, you'll have to keep user credentials for
database if SQL Server authentication is used (can we ask the user on
uninstall?)
For those who drop on uninstall, how do you proceed?
André Felipe Werlang
Antes de imprimir pense em seu compromisso com o Meio Ambiente
e o comprometimento com os Custos
-----Mensagem original-----
De: Neil Sleightholm [mailto:n...@x2systems.com]
Enviada em: 28 de agosto de 2009 14:31
Para: General discussion for Windows Installer XML toolset.
Assunto: Re: [WiX-users] SQL Script Deployment
This is how I run a sql script:
http://neilsleightholm.blogspot.com/search/label/SQL, although I don't
drop on uninstall but that could be arranged.
Neil
-----Original Message-----
From: Lourens Wepener [mailto:lourens.wepe...@avanade.com]
Sent: 28 August 2009 16:42
To: wix-users@lists.sourceforge.net
Subject: [WiX-users] SQL Script Deployment
Hi,
I am trying to get WIX to deploy a SQL database script.
We are building a database project using VSTS 2008 and deploying it
locally (on build server). When VSTS deploys, it creates a
databaseName.sql file. This file contains the script to drop / create
the database / permissions / views etc and also insert data that exists
in the post deploy scripts.
So, I would like to run this script with WIX, to create the database and
then drop the database on uninstall. This type of script also needs to
be run in SQL CMD mode.
What is the best way to achieve this?
I have tried various ways and have had no luck, the best / closest way I
got was to have a master sqldatabase under product and then sclscript as
a component that would create the database. But that returns a parse
error.
Please let me know if you need any more info :)
Many Thanks in advance.
Lourens
------------------------------------------------------------------------
------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008
30-Day
trial. Simplify your report design, integration and deployment - and
focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
