[wix-users] Database Path during Installation

[Ven H]

I have to create databases and then tables and other objects using MSI. For
the Data and Log file path, there is a screen to capture and these are
stored in 2 different properties and these values are also populated into
the Registry using CA. When the MSI executes to create the DB, it gets
these paths from Registry (logic is written into the sql file) and has to
create the data and log files. But unfortunately, these folders don't seem
to be getting created. For Application files, if a folder doesn't exist,
MSI seems to be creating it on the fly, but not for database.

So, I believe I have to create them manually and also rollback them during
exceptions. Is this the correct understanding.

Also, if I have to create them manually, at what stage should I be creating
them and should I be using CA or some other way?

If the Application also would use the same path and if it already finds
that path, will there be any issue?

Please help.