run sql create scripts from setup proj

[strugglingdeveloper]

I have a web application that connects to a sql database. I have create
scripts to create the needed database. I have also create a web setup
project that installs the web application on a server. Can I also execute
the sql scripts on a remote database server (not the web server) from inside
my web setup project? If so, how?

Additionally, can I have the setup project make web.config modification
during the install to ensure the database connection string is correct? If
so, how?

Thanks for any assistance.

 

[Ashish]

I have a web application that connects to a sql database. I have create
scripts to create the needed database. I have also create a web setup
project that installs the web application on a server. Can I also execute
the sql scripts on a remote database server (not the web server) from inside
my web setup project? If so, how?

Additionally, can I have the setup project make web.config modification
during the install to ensure the database connection string is correct? If
so, how?

Thanks for any assistance.

are you using a msi for websetup project ?, if so you can add a custom
action to the project, and launch a exe from there ..., connect to db
using standard ado and stuff..., or use the command line utilitiy isql
to run the sql statements ...

HTH