DB Pro (data dude) and Wix3 SqlExtension
I am trying to use Wix to create a database during installation. I have a database setup with Db Pro Visual Studio SKU (Data Dude as it is sometimes called). However, the output seems to be consumed only by sqlcmd.exe as it uses certain syntax in it (variable references like :setenv
and $(FOO)
).
I am trying to use wix sqlextension which does not appear to use sqlcmd.exe (I have not yet learned what data access technology it uses yet.
Does anyone know if there is a way to use the dude output natively in the wix sqlextension, or alternately if there is something that will take the sqlcmd output and translate it into executable sql code needed to execute on the sql server?
Note that the end goal is to fully integrate wix into our build system, so I'm looking for an automated approach.
source to share
There is a blog post that covers calling the sqlcmd.exe utility from WiX 3 at http://neilsleightholm.blogspot.com/2008/08/executing-sqlcmd-from-wix.html
source to share
If you created the package using Visual Studio DBPro, it is better to use VSDBCMD.exe to deploy the DB. The advantage of this is that VSDBCMD.exe always detects the target differential for the source and creates a delta script that can be run from the same command line. You just need to provide / action: Expand.
source to share