Types in the site name and submits form (after secure login of course)
This kicks off some process on our dedicated server that
Creates a new SQL server database (we can’t use CE as we have legacy stored
procs)
Runs a db install script
Creates a folder in wwwroot to reflect the site name entered above
Copies the sites files (stored on server) to wwwroot/SiteName
Sets up file permissions
Adds the site to IIS
Obviously, we’d rather not let the client have direct access to the server
otherwise we could look to use the Web PIatform Installer, unless we can kick this off via a script?
Anyone got any tips on what route to go down with this?
Would be pretty simple to implement, you can create a SQL script for the entire blank Umbraco database which you could turn into a stored proc that had a couple of parameters to allow you to change the DB name and to setup the DB user.
Then you could script the copying of your site files from your "source" folder into a new root folder as you mentioned above, you can then script the directory permissions using something like SetACL ( mentioned on my blog.. but there are other ways as well ) and then finally you can then script the setup of the web.config file's DB settings.
I don't have this out of the box to give you, but I think the above should be relatively easy to implement.
Remote automated install of Umbraco project
Rich
Hi Rich,
Would be pretty simple to implement, you can create a SQL script for the entire blank Umbraco database which you could turn into a stored proc that had a couple of parameters to allow you to change the DB name and to setup the DB user.
Then you could script the copying of your site files from your "source" folder into a new root folder as you mentioned above, you can then script the directory permissions using something like SetACL ( mentioned on my blog.. but there are other ways as well ) and then finally you can then script the setup of the web.config file's DB settings.
I don't have this out of the box to give you, but I think the above should be relatively easy to implement.
Cheers,
Chris
Hey Chris,
Cheers for your reply.
Looks simple enough in theory, though no idea how to script against IIS to create the new site.
From twitter it seems a few have tried to achieve what I'm trying wihtout too much luck.
Seems like Web PI might be the way forward as it would do everything, not sure if it can be kicked it off remotely though.
Rich
Rich,
My suggestion would be to just Google "script creating an IIS site"
I just did and found lots of articles :)
One on the Microsoft site related to IIS 6 (may work in IIS 7?! ):
http://support.microsoft.com/kb/816568
But there were a lot of other links that had other examples.
Cheers,
Chris
is working on a reply...