Create installationfile

[pelle.mia]

Hello Guru's!

I'm developing an intranet-application in IIS/ASP (not .NET) with MSSQL2000. I use 'Stored Procedure' as much as possible and call theese from ASP-pages. Now my problem:

I'd like to create an installationfile/program that can be used to install my application at costomers. I'm just an beginner, though I realize that my ASP-pages can be packaged into som install-software, but can SP's be included there also.

I'd really be happy if someone could help me with this, and if som has an URL that tell me more.

Hello from Sweden!

[MAK]

If you are going to install sql client on the client side Look into ISQL, OSQL utility of sql server.


The way in my previous client we do is backup the entire database which has only database schema, procs and trigger etc with no data. we just restore the database. You can create a VB setup package which can restore the database.

[MAK]

you can also run commands like sp_attach_db from VB to attach .mdf and .ldf files.


http://www.vbdotnetheaven.com/Code/Jul2003/2130.asp

--using mdf file
http://www.experts-exchange.com/Prog..._20549034.html


--using DMO

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=564

[pelle.mia]

I will read all that documents with great "passion".