Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
uberbloke
Yak Posting Veteran
67 Posts |
 Posted - 2002-04-10 : 06:30:15
|
| I have an ASP / SQL Server Application (nice!), we currently run this as a hosted solution.The problem is we would like for market this as a standalone, fire and forget, shrinkwrapped product (buy the cdrom and away you go), so...I need to burn a cdrom that contains all the required information, that when setup.exe :-) is fired unpack itself, deploy to directories and run SP's to create Tables, SPs, UDFs etc.I also want the deployment to be licence key'd so that the SQL Server can 'grab' certain information (like how many concurrent sessions are allowed)(...I may also want to optionally install other bits of software like SA-SMTPmail...)I can assume that the whoever buys the CDROM will already have a machine with SQL Server and IIS installed...Where on earth do I start...Any help/advice greatly appreciated... |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-04-10 : 14:18:54
|
| Well, for the code to build the tables, sprocs, UDFs, etc. you can write a script and save it in a text file, then call osql as a command-line command passing in your script file as an input file. You can also have an output file if you want to check for errors.------------------------GENERAL-ly speaking... |
 |
|
|
|
|
|
|
|
Server & Script Deployment