I am creating an installer that will install MS SQL Express 2014 as a Prerequisite. Then install a website as the main feature (Which will run on the client machine as a service).
I need to run some SQL scripts before the main feature "service" gets created/started on the machine (using a Custom Action).
I need to know when in the installation process the SQL Database Scripts run (Specifically what execution stage (After Install Execution>Preparing? ), so I know when to run my custom actions to create/start the service.
Also I am trying to use the Server>SQL Databases>SQL Script>Script Replacement feature. I want to search and replace the path for the (mdf and ldf) sql files and place them in the APPDIR (property) that is chosen in the FolderDlg.
When I have tried to use APPDIR, it does not show up as a property that is available. I have tried moving the FolderDlg up in the process (Pre-install-UI under WelcomePrereqDlg), but still does not show up.
Any help would be greatly appreciated.
Thanks,
Doug