Re: [WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0

2008-08-11 Thread Eitan Behar
Hi, Please, can you expand a little more on how to load the scripts into a sqlstring and use the properties? I only saw how to assign SqlString explicit scripts, and not reading the scripts from a .sql file in the Binary table. Thanks in advance, Eitan On Fri, Aug 8, 2008 at 12:40 AM,

Re: [WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0

2008-08-11 Thread Christopher Karper
No, you're right, you can only assign explicit scripts. By load, I meant copy paste. The two elements have different capabilities, and unfortunately for you, you're looking for one that's only available with SqlString. You either have to cut paste your statements into the .wxs, or write your

Re: [WiX-users] Dynamically naming a database during its installation

2008-08-11 Thread Eitan Behar
Of Christopher Karper Sent: Monday, August 11, 2008 8:10 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0 No, you're right, you can only assign explicit scripts. By load, I meant copy paste

Re: [WiX-users] Dynamically naming a database during its installation

2008-08-11 Thread Christopher Karper
Sent: Monday, August 11, 2008 8:10 PM To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0 No, you're right, you can only assign explicit scripts. By load, I meant copy paste

[WiX-users] Dynamically naming a database during its installation

2008-08-07 Thread Nic Barden
Hi guys, I am trying to use the SqlDatabase and SqlScript elements to install a database and run some scripts to generate stored procs and tables etc. What I would ideally like is the user to be able to specify the database name in the setup UI, and then use that within the scripts. The

[WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0

2008-08-07 Thread Nic Barden
Sorry forgot to mention I am running the latest WiX version - 3.0.4318.0. And SQL 2005 if that makes any difference. Hi guys, I am trying to use the SqlDatabase and SqlScript elements to install a database and run some scripts to generate stored procs and tables etc. What I would ideally

Re: [WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0

2008-08-07 Thread Christopher Karper
There is not anything built in to Wix right now that will let you use variables in SqlScripts. You can load them into SqlString elements and use the normal [property] syntax. You can build a CA that will do this as well, which is what I did. Good luck! Chris On Thu, Aug 7, 2008 at 5:01 PM,

Re: [WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0

2008-08-07 Thread David Reed (SQL)
Sent: Thursday, August 07, 2008 14:40 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Dynamically naming a database during its installation - WiX VERSION 3.0.4318.0 There is not anything built in to Wix right now that will let you use variables in SqlScripts. You