Here is a Wix Fragment I use... this should get you going... Be sure to set the Guids...
Hope it helps, John -=- <?xml version="1.0" encoding="UTF-8"?> <Wix xmlns="http://schemas.microsoft.com/wix/2006/wi";> <?define SHARED3rdParty_PATH = "..\Shared\3rdParty"?> <Fragment> <DirectoryRef Id="PRODUCTBASEDIR"> <Directory Id="DatabasesBin" Name="Databases"> <Directory Id="Installer" Name="Installer"> <Component Id="c.ms.SP.tools.schema" Guid="{ }"> <File Id="f.ms.SP.tools.schema" Source="$(var.SHARED3rdParty_PATH)\SSDT\SQLPackager86\Microsoft.Data.Tools.Schema.Sql.dll" KeyPath="yes" Checksum="yes"/> </Component> <Component Id="c.ms.SP.tools.util" Guid="{}"> <File Id="f.ms.SP.tools.util" Source="$(var.SHARED3rdParty_PATH)\SSDT\SQLPackager86\Microsoft.Data.Tools.Utilities.dll" KeyPath="yes" Checksum="yes"/> </Component> <Component Id="c.ms.SP.dac" Guid="{}"> <File Id="f.ms.SP.dac" Source="$(var.SHARED3rdParty_PATH)\SSDT\SQLPackager86\Microsoft.SqlServer.Dac.dll" KeyPath="yes" Checksum="yes"/> </Component> <Component Id="c.ms.SP.scriptdom" Guid="{}"> <File Id="f.ms.SP.scriptdom" Source="$(var.SHARED3rdParty_PATH)\SSDT\SQLPackager86\Microsoft.SqlServer.TransactSql.ScriptDom.dll" KeyPath="yes" Checksum="yes"/> </Component> <Component Id="c.ms.SP.types" Guid="{ }"> <File Id="f.ms.SP.types" Source="$(var.SHARED3rdParty_PATH)\SSDT\SQLPackager86\Microsoft.SqlServer.Types.dll" KeyPath="yes" Checksum="yes"/> </Component> <Component Id="c.ms.SP.exe" Guid="{ }"> <File Id="SQLPACKAGE.exe" Source="$(var.SHARED3rdParty_PATH)\SSDT\SQLPackager86\SqlPackage.exe" KeyPath="yes" Checksum="yes"/> </Component> <Component Id="c.ms.SP.cfg" Guid="{ }"> <File Id="f.ms.SP.cdf" Source="$(var.SHARED3rdParty_PATH)\SSDT\SQLPackager86\SqlPackage.exe.config" KeyPath="yes" Checksum="yes"/> </Component> </Directory> <Directory Id="Support" Name="Support"> <Directory Id="dir.x86" Name="x86"> <Component Id="c.ms.x86.dacframework" Guid="{ }"> <File Id="f.ms.x86.dacframework" Source="$(var.SHARED3rdParty_PATH)\SSDT\Support\x86\dacframework.msi" KeyPath="yes" Checksum="yes"/> </Component> <Component Id="c.ms.x86.SQLDOM" Guid="{ }"> <File Id="f.ms.x86.SQLDOM" Source="$(var.SHARED3rdParty_PATH)\SSDT\Support\x86\SQLDOM.msi" KeyPath="yes" Checksum="yes"/> </Component> <Component Id="c.ms.x86.SQLLS" Guid="{ }"> <File Id="f.ms.x86.SQLLS" Source="$(var.SHARED3rdParty_PATH)\SSDT\Support\x86\SQLLS.msi" KeyPath="yes" Checksum="yes"/> </Component> <Component Id="c.ms.x86.SQLSysClrTypes" Guid="{}"> <File Id="f.ms.x86.SQLSysClrTypes" Source="$(var.SHARED3rdParty_PATH)\SSDT\Support\x86\SQLSysClrTypes.msi" KeyPath="yes" Checksum="yes"/> </Component> </Directory> <Directory Id="dir.x64" Name="x64"> <Component Id="c.ms.x64.dacframework" Guid="{}"> <File Id="f.ms.x64.dacframework" Source="$(var.SHARED3rdParty_PATH)\SSDT\Support\x64\dacframework.msi" KeyPath="yes" Checksum="yes"/> </Component> <Component Id="c.ms.x64.SQLDOM" Guid="{}"> <File Id="f.ms.x64.SQLDOM" Source="$(var.SHARED3rdParty_PATH)\SSDT\Support\x64\SQLDOM.msi" KeyPath="yes" Checksum="yes"/> </Component> <Component Id="c.ms.x64.SQLLS" Guid="{ }"> <File Id="f.ms.x64.SQLLS" Source="$(var.SHARED3rdParty_PATH)\SSDT\Support\x64\SQLLS.msi" KeyPath="yes" Checksum="yes"/> </Component> <Component Id="c.ms.x64.SQLSysClrTypes" Guid="{}"> <File Id="f.ms.x64.SQLSysClrTypes" Source="$(var.SHARED3rdParty_PATH)\SSDT\Support\x64\SQLSysClrTypes.msi" KeyPath="yes" Checksum="yes"/> </Component> </Directory> </Directory> </Directory> </DirectoryRef> </Fragment> <Fragment> <ComponentGroup Id="SSDT_Installer"> <ComponentRef Id="c.ms.SP.tools.schema" /> <ComponentRef Id="c.ms.SP.tools.util" /> <ComponentRef Id="c.ms.SP.dac" /> <ComponentRef Id="c.ms.SP.scriptdom" /> <ComponentRef Id="c.ms.SP.types" /> <ComponentRef Id="c.ms.SP.exe" /> <ComponentRef Id="c.ms.SP.cfg" /> </ComponentGroup> <ComponentGroup Id="SSDT_Installer_Support"> <ComponentRef Id="c.ms.x86.dacframework" /> <ComponentRef Id="c.ms.x86.SQLDOM" /> <ComponentRef Id="c.ms.x86.SQLLS" /> <ComponentRef Id="c.ms.x86.SQLSysClrTypes" /> <ComponentRef Id="c.ms.x64.dacframework" /> <ComponentRef Id="c.ms.x64.SQLDOM" /> <ComponentRef Id="c.ms.x64.SQLLS" /> <ComponentRef Id="c.ms.x64.SQLSysClrTypes" /> </ComponentGroup> </Fragment> </Wix> -=- -----Original Message----- From: Vani Rao [mailto:vani...@microsoft.com] Sent: Sunday, May 25, 2014 11:38 PM To: General discussion about the WiX toolset. Subject: Re: [WiX-users] Wix Changes after converting VSDB to SQLPROJ Thanks John. I have a .DACPAC file created from the SSDT. What are the redistributables do I need to add for this kind of project? Thanks, Vani -----Original Message----- From: John H Bergman (XPedient) [mailto:john.berg...@xpdnt.com] Sent: Friday, May 23, 2014 1:04 AM To: General discussion about the WiX toolset. Subject: Re: [WiX-users] Wix Changes after converting VSDB to SQLPROJ Change the command line to run the SqlPublisher, and update the installer to include the redistributables. -----Original Message----- From: Vani Rao [mailto:vani...@microsoft.com] Sent: Thursday, May 22, 2014 2:21 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Wix Changes after converting VSDB to SQLPROJ Hi, I am new to Wix. I have requirement. We have converted the VS2010 .dbproj to SQLPROJ. I need to make changes to the existing wix project to install this SSDT. What are the changes that I need to do for the Wix project? Thanks, Vani ------------------------------------------------------------------------------ "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE Instantly run your Selenium tests across 300+ browser/OS combos. Get unparalleled scalability from the best Selenium testing platform available Simple to use. Nothing to install. Get started now for free." http://p.sf.net/sfu/SauceLabs _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ The best possible search technologies are now affordable for all companies. Download your FREE open source Enterprise Search Engine today! Our experts will assist you in its installation for $59/mo, no commitment. Test it for FREE on our Cloud platform anytime! http://pubads.g.doubleclick.net/gampad/clk?id=145328191&iu=/4140/ostg.clktrk _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ The best possible search technologies are now affordable for all companies. Download your FREE open source Enterprise Search Engine today! Our experts will assist you in its installation for $59/mo, no commitment. Test it for FREE on our Cloud platform anytime! http://pubads.g.doubleclick.net/gampad/clk?id=145328191&iu=/4140/ostg.clktrk _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
