run sql create scripts from setup proj

  • Thread starter Thread starter strugglingdeveloper
  • Start date Start date
S

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.
 
strugglingdeveloper said:
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.
Click to expand...
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
 
Back
Top