[wix-users] Delivering a SQLite DB

[Hoover, Jacob]

LocalAppDataFolder if it was per user. You need to decide if it's per machine or per user.  A common option is to install a default DB for a per machine install in a non-user writable dir, and have the app copy it to LocalAppDataFolder on first run (if the file doesn't exist).

-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Paul J. McMillan, Sr.
Sent: Wednesday, July 5, 2017 4:43 PM
To: 'WiX Toolset Users Mailing List' <wix-users at lists.wixtoolset.org>
Subject: Re: [wix-users] Delivering a SQLite DB

I'm new to Wix.  How do I tell Wix to install the DB file in C:\Users\[UserName]\AppData\Local\MyApp\ folder?

-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Habib Salim
Sent: Wednesday, July 5, 2017 5:39 PM
To: WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
Subject: Re: [wix-users] Delivering a SQLite DB

I gather you are just copying a database file of some sort.
If so, you can specify the path any which way you like

I imagine this would work:
<Fragment>
	<Directory Id ="DATABASEDIR" Name ="DatabaseDirectory" />
	<ComponentGroup Id ="DatabaseComponents" Directory="DATABASEDIR" >
		<Component ...>
			<File ... />
		</Component>
	</ComponentGroup>
</Fragment>






-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Paul J. McMillan, Sr.
Sent: Wednesday, July 05, 2017 5:30 PM
To: 'WiX Toolset Users Mailing List' <wix-users at lists.wixtoolset.org>
Subject: Re: [wix-users] Delivering a SQLite DB

The problem I am running into is, the app along with the DB is getting installed under ProgramFiles and a standard user will not permission to write to the file.  So, I'm trying to put the file in a place that the user will have write access to such as Local App Data Folder but I can't find a way to do that.

-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Habib Salim
Sent: Wednesday, July 5, 2017 5:24 PM
To: WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
Subject: Re: [wix-users] Delivering a SQLite DB

I have a similar client/server application The main installer installs the application, uses a custom dialog to capture server, database, license keys and anything else.
You can then update your application.config or registry or database.

A separate install, which I haven't started on (currently handling
manually) , will create the database and required objects, import application meta data etc You will probably use a custom task for this.
I'll probably use JetBA when I eventually get around to it - I will need a Bootstrapper to install .netFW and other dependencies anyway.



-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Paul J. McMillan, Sr.
Sent: Wednesday, July 05, 2017 5:09 PM
To: wix-users at lists.wixtoolset.org
Subject: [wix-users] Delivering a SQLite DB

Hi, 

 

I'm trying to get Wix to allow me to do a perMachine install but at the same time put my SQLite DB in a place where the user can read and write to it.
Does anyone have any ideas?

 

Thanks,

Paul 


____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/
(null)

____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/


____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/

____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/


____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/