I have a scenario where I have to restore a database from an mdf/ldf on to
the target machine during the installation which I was planning on
accomplishing by :
1) Copying the mdf/ldf to a *MySoftware/Data* folder
2) Calling a sql script *AttachDB.sql* (using the SqlScript
element) which
does a *EXEC sp_attach_db* and attachs the mdf to a newly created database
but the roadblock I see is that I want to attach the mdf from the *
MySoftware/Data* (from step 1) which is configurable by the user to be
installed on any drive.
Neither attaching the mdf from the CD like shown below or using a hardcoded
*MySoftware/Data* location does not help in this case;
*AttachDB.sql*
EXEC sp_attach_db @dbname = 'MyCDatabase',
@filename1 = 'E:\CD_DriveFolder\WiXTest.mdf',
@filename2 = 'E:\CD_DriveFolder\WiXTest_log.ldf'
Can something like this be done from WiX without using a VBScript?
Jacob
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
