I use windows server 2008r2 server and iis7
I created an msi installer containing two .net applications.so once the setup is installed it would create two virtual directories in iis from where i would access the applications. For restoring the database of these applications i created a batch file that would trigger a file xxx.sql which contains the restore database commands.I have created the setup in such a way that once installation is done the batch file would be placed in user's desktop so that he can run the file to restore Database.
but i need a solution wherein the batch file should not be manually run by the user. It should also get restored as a part of installation process and right now i am restoring it on my local server. i need to have a wizard in my msi installer that would ask the user for his credentials,name of the server where it should get restored and once user enters these details and clicks next it should restore database onto the server where user has mentioned.
Pls help me out with this problem...
Any help will be appreciated greatly
Thanks in advance