Running Sql Script File (*.Sql) Through Setup(msi) ...

Question

Hi all I'm not Familiar with creating Setup in VS.NET. I want to create a setup(MSI) for my web-application and create my Database (Sql-Server 2000) through this setup.So i generated TSql script of my database and its related such as stored procedured(s)Table(s) and etc.But As you know with OSQL.ExE Utility we can run Tsql Script file (*.Sql) from command line for example: Osql.ExE /E /i Test.Sql So i must create a custom action(as far as i know)in my setup for running Osql.exe BUT I DON'T KNOW HOW SHOULD I DO THIS.? Is it possible to help me.? Best Regards.

p.jones · Answer

You know then that within your solution you set up a new project of the setup type. Then you write a module in your main project. Then I think you add that as a custom action within the setup project. I have not done a custom action yet but I have completed a setup project. Go to visual studio->help->search->custom actions management in deployment and you will get detailed steps.

engr_zmk · Answer

I did it through Sax an installer software. First i execute the script and then the setup of my application(created in VS.Net).