The AI blog

To know the difference :  Go to here

http://technet.microsoft.com/hi-in/sqlserver/bb331794(en-us).aspx Go

To know more :  go to here

DeploymentEngineering.com - The Blog: Multiple Instance MSI's and InstallShield 12

At my last job, I was responsible for build and install for a single tenant SaaS system that consisted of ASP.NET WebServices, WinUI and WebUI clients. This system lent itself to needing the ability to have different versions installed in parallel with different configuration options. At the time, InstallShield 12 had the ability to generate and embed product code changing multiple instance transforms but the bootstrapper lacked the ability to service these instances. As a result I authored a custom bootstrapper that interacted with the MSI API and simple reflection against the MSI database to connect the pieces into a solution that looked very much like InstallScripts multiple instance support. In fact I wrote about this on my blog: Multiple Instance MSI's and InstallShield 12 . This blog article has continued to be very popular among my visitors.

Stephane Rodriguez posted an interesting comment that I hadn't thought of - it isn't the easiest thing in the world to download Orca. You have to go through the Platform SDK web-based installer tool and also install a bunch of pieces of the core SDK to get orca.msi which lets you install Orca. I have a copy of it that I downloaded and posted at http://astebner.sts.winisp.net/Tools/Orca.zip for easier access. I hope this makes things easier for you as you debug your setup packages.

DECLARE @docHandle int DECLARE @xmlDocument nvarchar(max) -- or xml type SET @xmlDocument = N' ABC123 ABC1233232 ' EXEC sp_xml_preparedocument @docHandle OUTPUT, @xmlDocument -- Use OPENXML to provide rowset consisting of customer data. --INSERT Customers declare @Test nvarchar(10) declare @Test2 nvarchar(10) SELECT @Test=text FROM OPENXML(@docHandle, N'/Parameters/Parameter[@name=''Test'']/text()') SELECT @Test2=text FROM OPENXML(@docHandle, N'/Parameters/Parameter[@name=''Test2'']/text()') print @Test print @Test2 -- WITH Customers -- Use OPENXML to provide rowset consisting of order data.