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

ShellProgrammer

22y4.1k

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

p.jones22y ago
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.
0
engr_zmk22y ago
I did it through "Sax", an installer software. First i execute the script and then the setup of my application(created in VS.Net).
0