i've created one web application. and used backend, sql server 2008. now its running well in my system. my question is, how to run this application in another system, even that system not having visual studio and database files and all. but have to run on another system. what i do now? say the procedures.
asked Sep 10, 2012 at 07:09 AM in Default
In short, you need to right click on the web project and then click publish. Then choose the destination (i like ftp), then you need to sync your database with the production server by use of visual studio or red gate tools or something.
answered Sep 20, 2012 at 01:59 PM
There are many ways to do this and no one good or bad way (ok there is bad).
If you are looking to deploy this on a client site then you could develop an MSI that deploys the website/services along with IIS configuration, SQL Server installation (licensing restriction apply if using anything other than express/compact). The MSI would assume (IMO) that nothing is installed (or would check for a component existence) and apply the relevant software/prereq's. This as an end user would be my pref if installing a 3rd party tool/app.
Internally for our sites/services we use a product called cruise control is used to auto deploy DEV/QA and Live environments (time and effort has to be invested in creating the relevant deploy scripts). I, as the DBA then deploys any DBs/script into our production environment(s).
Maybe a little background on what your scenario is would help me answer with a little more depth.
answered Sep 20, 2012 at 02:18 PM