lf to run the same script.
-Original Message-
From: Rob Mensching [mailto:r...@robmensching.com]
Sent: Thursday, January 23, 2014 4:39 PM
To: General discussion about the WiX toolset.
Subject: Re: [WiX-users] SqlScript with large schema setup
Code was originally written sometime around 200
Code was originally written sometime around 2001. It hasn't changed really
since then.
-Original Message-
From: Levi Wilson [mailto:l...@leviwilson.com]
Sent: Thursday, January 23, 2014 2:31 PM
To: General discussion about the WiX toolset.
Subject: Re: [WiX-users] SqlScript with
; From: Levi Wilson [mailto:l...@leviwilson.com]
> Sent: Thursday, January 23, 2014 12:30 PM
> To: General discussion about the WiX toolset.
> Subject: Re: [WiX-users] SqlScript with large schema setup
>
> What are other ways that people have gotten around it? It doesn't seem
>
I assume most people live with the perf since no one has ever bothered to fix
the bug.
-Original Message-
From: Levi Wilson [mailto:l...@leviwilson.com]
Sent: Thursday, January 23, 2014 12:30 PM
To: General discussion about the WiX toolset.
Subject: Re: [WiX-users] SqlScript with large
14 10:41 AM
> To: wix-users@lists.sourceforge.net
> Subject: Re: [WiX-users] SqlScript with large schema setup
>
> Sorry I didn't mention this before, but the database is already going to
> exist. Our customers create this beforehand. The installer will just be
> running the SQL scrip
--
From: Levi Wilson [mailto:l...@leviwilson.com]
Sent: Thursday, January 23, 2014 10:41 AM
To: wix-users@lists.sourceforge.net
Subject: Re: [WiX-users] SqlScript with large schema setup
Sorry I didn't mention this before, but the database is already going to exist.
Our customers cr
Sorry I didn't mention this before, but the database is already going to
exist. Our customers create this beforehand. The installer will just be
running the SQL script for the initial schema to create all of our tables,
triggers, sprocs, etc.
When looking at the installer log, I see two lines that
I am using a to create our database schema. I exported the
schema using RedGate. The file is 10MB (I know, I know...). Everything
works as expected, but during the installation the "Configuring SQL Server"
takes forever.
I know, 10MB file with 144k lines of SQL to parse is a lot...is there a
bett
Why not right click on the DB, tasks and generate in MS? What version of
SQL?
On Thu, Jan 23, 2014 at 10:52 AM, Levi Wilson wrote:
> I am using a to create our database schema. I exported the
> schema using RedGate. The file is 10MB (I know, I know...). Everything
> works as expected, but duri
I am using a to create our database schema. I exported the
schema using RedGate. The file is 10MB (I know, I know...). Everything
works as expected, but during the installation the "Configuring SQL Server"
takes forever.
I know, 10MB file with 144k lines of SQL to parse is a lot...is there a
bett
opley [mailto:simon.top...@wallingfordsoftware.com]
Sent: Friday, November 13, 2009 11:23 AM
To: wix-users@lists.sourceforge.net
Subject: Re: [WiX-users] SQLScript
There seems to be a huge overhead of running sql scripts from within
windows installers so I'm playing with the idea of using skeleton
users@lists.sourceforge.net
Subject: Re: [WiX-users] SQLScript
I found another solution, a bit ugly but it seems to work. I'm using
QtExecCmdLine to run sqlcmd.exe with all of the relevant info. Might be
useful to others.
Simon
-Original Message-
From: Simon Topley
Sent: 16 November 2009 09:
I found another solution, a bit ugly but it seems to work. I'm using
QtExecCmdLine to run sqlcmd.exe with all of the relevant info. Might be
useful to others.
Simon
-Original Message-
From: Simon Topley
Sent: 16 November 2009 09:25
To: wix-users@lists.sourceforge.net
Subject: Re: SQLScri
Cheers Rob,
I may fix it for you if I can't find another solution. MDF files are out
as there are issues between versions of SQL server apparently.
Simon
Disclaimer: This electronic communication and its attachments may contain
confidential, proprietary and/or legally privileged information whic
There is a performance issue with the SqlScript custom action. It hasn't
been fixed yet.
SqlFileSpec cannot be used to attach .mdf files/.ldf files. Instead, install
the .mdf/.ldf files then use a SqlString to run the ATTACH SQL command. (I
forget the exact syntax but I've used that in a past life
There seems to be a huge overhead of running sql scripts from within
windows installers so I'm playing with the idea of using skeleton
databases stored in MDf/LDF files, I see there are sqlFileSpec elements
that handle these but i can't get them towork yet, I'm not usinga
script just 2 files and th
h, it seems that you can run scripts that cahnge other databases
outised of the sqldatabse element the scrit is inside of so maybe it'sa
size issue.
The script I'm trying to run is 16mb... about 300,000 lines of SQL. This
takes about 3 minutes to run if you do it manually.. I've split the file
Hello again team, I've got another issue with some SQL scripts I'm
trying to run. I have a large collection of scripts all of them work as
they each refer to a specific databasehowever I have one big script
that updates tables in multiple databases so I can't put it in one
specific SqlDatabase
Hello Every1, my client asked me to make the installer use a script to install
database, the problem his he wants to give the script during the installation
UI sequence so I can't use sqlscript because it demands a hardcoded file, I
cannot use xp_cmdconsole because its considered a security haza
>
>
>
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:
> [EMAIL PROTECTED] On Behalf Of Dana Gutride
> Sent: Friday, August 15, 2008 06:58
> To: Windows Installer XML toolset developer mailing list; General
> discussion for Windows Installer XML toolset.
ler XML toolset.
Subject: [WiX-users] SqlScript Connection Question
Quick question regarding the way the WiX sql custom actions. When you
specify multiple sql scripts or strings with their associated sequences,
does the custom action open a new connection for each string/script executed
or does it reuse
Quick question regarding the way the WiX sql custom actions. When you
specify multiple sql scripts or strings with their associated sequences,
does the custom action open a new connection for each string/script executed
or does it reuse the connection until it has looped through all of the
scripts
> I thought a patch installer (.MSP) did not have a UI. You might have a
> more controlled environment, but without a UI we couldn't prompt for SQL
> credentials and thus couldn't run SQL Scripts in a patch. If you can
> hard code credentials or there actually is some way to display a dialog
> to
> > This fails giving the following error in the log.
> >
> > Action start 11:04:08: InstallSqlData.
> > InstallSqlData: Error 0x80070006: failed to get size of stream
> > InstallSqlData: Error 0x80070006: failed to read SqlScripts table
>
> Try using pyro's -notidy argument. Very helpful to
PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chad Petersen
Sent: Wednesday, July 16, 2008 10:50 AM
To: General discussion for Windows Installer XML toolset.
Subject: Re: [WiX-users] SqlScript, XmlFile, Pyro and patching
I thought a patch installer (.MSP) did not have a UI. You might have a
more
ject: [WiX-users] SqlScript, XmlFile, Pyro and patching
Hi,
I'm trying to create a patch using Pyro (Version 3.0.4227.0). Our
product installer performs various functions, installs
executables/services, runs SqlServer scripts, configures settings files
based upon user settings etc. I now w
Colin Law wrote:
> This fails giving the following error in the log.
>
> Action start 11:04:08: InstallSqlData.
> InstallSqlData: Error 0x80070006: failed to get size of stream
> InstallSqlData: Error 0x80070006: failed to read SqlScripts table
Try using pyro's -notidy argument. Very helpful
Hi,
I'm trying to create a patch using Pyro (Version 3.0.4227.0). Our product
installer performs various functions, installs executables/services, runs
SqlServer scripts, configures settings files based upon user settings etc. I
now wish to create a patch to update installed files, but also ex
Can you point me to documentation or an example that shows how to add a
SqlClr stored procedure to a wix install?
I have assemblies and stored procedures that I am able to build and deploy
outside of wix, however, when I try to create the assemblies in the same
order in my wix install it fails.
S
Hi,
Is there any way to run a SqlScript under elevated user on Vista ? I know
there is a way for a custom action but I'd like to use built-in SqlDatabase
and SqlScript elements. It seems as there is an Impersonate attribute
missing for SqlDatabase element. I use Wix version 2.
I'm able to install
Chad Petersen wrote:
We were using Wix 2.0.3309.0 until recently
Much changes in a year and a half.
and the SQLScript element was working great. About a week ago we
updated to WiX 2.0.5325.0 and the SQLScript element is no longer
running our SQL scripts. I started looking at the older MSI
We were using Wix 2.0.3309.0 until recently and the SQLScript element
was working great. About a week ago we updated to WiX 2.0.5325.0 and the
SQLScript element is no longer running our SQL scripts. I started
looking at the older MSI packages that do work and the newer ones that
are failing. Using
This has been discussed extensively...
What is in your .sql script file? Do you have all the batches delimited by
"GO" statements? Use SQL Server Management Studio/Enterprise Manage to load
and save your scripts.
Let us all know if this helps.
On 6/2/07, rajiv ramanan <[EMAIL PROTECTED]> wrote
Hi all,
I seem to run into a problem while using the tag. The
following is the code i used and im using wix version 2.05. The script i am
using is just a sample to create a table. The query is fine. When i used
sqlstring the script is executed and when i used script its not working.
Please
: wix-users@lists.sourceforge.net
Subject: [WiX-users] SqlScript sample
Hi,
I am new in using WIX and while learning basics I faced a problem with the
SqlSample<http://www.wixwiki.com/images/c/c1/WixSqlDatabaseSample.zip> provided
on the wixwiki web site<http://www.wixwiki.com/index.php?t
Hi, I am new in using WIX and while learning basics I faced a problem with the
SqlSample provided on the wixwiki web site. I am simply unable to execute a msi
that hold a SqlScript section. I currently run the V.3.2420 version of wix and
I still don't understand why this sample didn't work fine.
Hi,
I am new in using WIx and while learning basics I faced a problem with the
SqlSample provided on the wixwiki web site. I am simply unable to execute a msi
that hold a SqlScript section.
I currently run the V.3.2420 version of wix and I still don't understand why
this sample didn't work f
sequencing issue.
Are you relying on the XMLFile task to update the xml files first?
Michael
-Original Message-
From: Jaap de Wolff [mailto:[EMAIL PROTECTED]
Sent: Thursday, 13 July 2006 4:21 PM
To: Michael Osmond; wix-users@lists.sourceforge.net
Subject: RE: [WiX-users] SqlScript and Cus
ant.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Michael
> Osmond
> Sent: donderdag 13 juli 2006 3:02
> To: Jaap de Wolff; wix-users@lists.sourceforge.net
> Subject: Re: [WiX-users] SqlScript and CustomActions
>
>
> Hell
EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jaap de
Wolff
Sent: Thursday, 13 July 2006 12:33 AM
To: wix-users@lists.sourceforge.net
Subject: [WiX-users] SqlScript and CustomActions
Hello,
I want to create a database, run an sql script to create tables etc.
then do a few custom actions, which
Hello,
I want to create a database, run an sql script to create tables etc. then do
a few custom actions, which fill the database, and then execute a few sql
strings.
The last sql strings contain values which depend on customer choices.
My question is:
Is there a way of scheduling custom actions b
41 matches
Mail list logo
