Microsoft Web Platform is a web installer software for products like:
- Visual Web Developer
- SQL Server Express
- Silverlight Tools
- IIS and ASP.NET Extensions and others
My target is download SQL Server Express 2008 installer and do a offline install. This is how it works:
- Go to MSDN download page.
- Download and install Microsoft Web Platform.
- Then choose to install SQL Server Express 2008 from the download page, skip the register and continue.
- Web Platform should be auto executed, then close the Web Platform.
- Go to C:\Documents and Settings\[User]\Local Settings\Application Data\Microsoft\Web Platform Installer
- Open a file called productCache184.108.40.206.xml using your favorite editor.
- Look for the <installerItems>, each product mentioned above should have 1 of these tags so you need to pick the one you want to install. For SQL Server Express 2008, you can see something like <eulaURL>http://www.iis.net/downloads/files/EULA/SQL_Express_2008.html</eulaURL>.
- Check out the <installerURL> tag, which contain the installer actual URL, for SQL Server Express 2008 it is http://go.microsoft.com/fwlink/?LinkID=146798.
- Download the installer using the URL you found, then double click it to install the product.
To offline install Visual Studio Express without download the whole image file, you might refer here.
To schedule your website to run a particular PHP file (to email or some other things):
- Go to your website control panel
- Go to Cron Job (it is the scheduler in Linux system)
- Usually you can choose GUI method or coding method to set the schedule
- You need to set the minutes, hours, dates, months and weekdays
- For the command to be run:
lynx -dump http://your.website.url/yourphpfile.php
lynx is the command to execute the PHP file
- Usually you can key in the email to be sent when the scheduler execute the commands
In Apache Tomcat, if we want to add a sub directory into an url, such as vicker313.wordpress.com/subdir, we will normally create a new directory at the [tomcat]\webapp directory, and put in the necessary web pages.
However if we need to put the web pages outside webapp, then we need to create a virtual directory in Tomcat:
- Go to [tomcat]\conf\Catalina\localhost (version that I used is 5.5).
- Create a xml file, named it as the name of the directory that store your web pages, for example subdir.xml.
- Put in the following code (assume your directory is c:\subdir):
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/subdir" docBase="c:/subdir" debug="0" privileged="true"></Context>
- Now you can access the site http://www.yoururl.com/subdir
It is also possible to point the virtual directory to a shared folder of another machine:
<Context path="/subdir" docBase="//192.168.1.2/subdir" debug="0" privileged="true"></Context>
Beware that the directory that you point must have the web pages, as lease an index.html. Or else it will just show out no resource error message (will not list out the content of the directory).
3 tiers replication means: after you setup a master site server and a MV site server, you then setup another MV site server that replicate from the middle tier MV site server. Reasons why we want to do this include:
- If you have several servers need to be setup as MV site servers, replicate from middle tier MV site server might able to lower the resource consumption on the master site server.
- Because setup a MV site server need the master site server to be static (no data changes during the setup), it might be unpractical for stopping the users from using the master site server. Make use a middle tier MV site server might be a solution for such situation, just stop the refresh job on it.
Steps to setup a 3 tiers replication:
- Setup the Master Site Server.
- Setup the Middle Tier MV Site Server.
- At the Middle Tier MV Site Server, create Materialized View Log on necessary tables:
create materialized view log on [table name];
- Setup the Third Tier MV Site Server, and treat the Middle Tier MV Site Server as the Master Site Server.