Sajo Jacob - All Comments

re: How to Chain TFS Builds?

spoov — Mon, 01 Mar 2010 21:58:20 GMT

Yes, you can do that easily, Solution A, B and C need nothing fancy in them, "AllSolutions" build will need something like my above solution highlighted in the blog post to make a call to Solution A, B and C.

re: How to Chain TFS Builds?

Geoff T — Mon, 01 Mar 2010 21:46:05 GMT

@JB : you could (probably) do selective builds like that with conditions in the builds themselves. I'm trying that right now on ours.

re: How to print EULA from WiX

spoov — Thu, 18 Feb 2010 22:59:31 GMT

Glad it helped! =)

re: How to Chain TFS Builds?

Jerry Brown — Thu, 18 Feb 2010 22:49:53 GMT

Would it be possible to chain multiple freestanding builds? This way, a continuous integration build for a solution would only trigger that solutions build, but a nightly could use the chaining to build all the solution.

SolutionA

TFSBuild.proj // Builds only solution A

SolutionB

TFSBuild.proj // Builds only solution B

SolutionC

TFSBuild.proj // Builds only solution C

AllSolutions

TFSBuild.proj // Builds A+B+C

re: WiX and Databases

foram — Mon, 15 Feb 2010 21:34:19 GMT

I want to connect to postgres database and perform the same functions as sqlstring and sqldatabase. what do you suggest i should do?

re: How to print EULA from WiX

lisathelugubrious — Mon, 08 Feb 2010 11:17:20 GMT

I was in quite a quagmire until I came across this post. Thanks a lot.

Twitter Trackbacks for SharePoint Conference 2009! - Sajo Jacob [claritycon.com] on Topsy.com

Wed, 07 Oct 2009 13:57:59 GMT

Pingback from Twitter Trackbacks for SharePoint Conference 2009! - Sajo Jacob [claritycon.com] on Topsy.com

re: Platform Agnostic apps failing on a 64 bit machine.

Bjørn Harald — Wed, 23 Sep 2009 13:28:33 GMT

It's CorFlags.exe ;-)

re: WiX and Databases

Abhimanyu — Tue, 12 May 2009 20:29:29 GMT

hi Sajo.. i have a situation where i take a back up of the database... execute a bunch of scripts (Ok so far) and then if an error is encountered, i need to restore the backup from the first step. i am seeing that WIX simply rolls back everything and i am not able to figure out how to execute the restore back up script? i have a custom action but how to execute it in case of an error condition? what do you think?

re: CustomActionData in WiX with Deferred Custom Actions

Moazzam — Fri, 17 Apr 2009 19:46:59 GMT

excellent post! but its not working for me.

I get a "object Required: Session" Error at the strArgs = Session.Property("CustomActionData") line!

how do you access the Session object in VBScript?

I tried to see if maybe the "CustomActionData" wasnt set right, so I tried to

ASSIGN a value to a session prop[erty, but even that wouldnt work!

how do you get a handle to the Session object in VBScript?

thanks!

re: WiX and Databases

spoov — Mon, 23 Mar 2009 16:23:48 GMT

Prabhakaran: Yes, use a VBScript call to determine if the instance already exists (see my earlier comment on how to do this) and do a check in WiX for the returned flag value and run the script accordingly.

Daniel: SQLString Sequence is not the same as InstallExecute Sequence. Its the sequence in which the SQLStrings will be run once the SQL actions begin. Seems your SQL Actions are running as immediate actions. Since the SQL Actions are automatically scheduled by the WIX SQLExtensions, I would open the MSI with Orca Editor and see the bits are set for the SQL Actions. Let me know what you find there. Good Luck!

re: WiX and Databases

Daniel — Mon, 23 Mar 2009 15:02:55 GMT

Hi,

I'm running a combination of SqlScript and SqlString as shown in this post.

This works fine. Now I want to run all SQL-Commands after the InstallFinalize

Action. I tried using the Sequence-Flag in SqlString/SqlScript, with no

luck; even if i set a Sequence-No greater than 6600, the SQL-Commands

will be executed before the files are installed.

Any help?

re: WiX and Databases

Prabhakaran — Thu, 05 Mar 2009 10:02:12 GMT

I am using Wix 2.0 and i need to create a database with the new instance 'Sample' and run the script to create tables and stored procedures. If that instance already exists it should then run the script to create tables and stored procedures.

Is there any way to acheive this?

re: WiX and Databases

spoov — Mon, 02 Mar 2009 23:01:23 GMT

Yes, I have done this in the past.

You can get the SQL Server information in couple of different ways via custom actions, be it a VBScript shelling out to OSQL or using SQL-DMO

Installing a Database and creating tables can all be done by using either SqlScript or a combination of SqlDatabase and SqlString as shown in this post.

Good Luck!

re: WiX and Databases

Krish — Sat, 28 Feb 2009 11:13:25 GMT

I need to get the SQL sever info from the user, and installs the db and tables

Is this possible using wix?