Migrating from ASP to WordPress(1)

TurnToJPG -->

Recently I will moving an old-style website from ASP to WorldPress, that’s a funny work. This series will record the steps for migrating. ###Preparation First I got all of the files which locates in the ASP.NET Server, the database is very simple, it’s a mdb file, which could be viewed by Microsoft Access.

The static files and images could also be downloaded from the server, thus the materials is enough for building a whole-new WorldPress based website.

###Using Python To Generate Content All of the webpage information are located in the mdb file, thus we have to do some dealing with this database file. Python could easily retrieve the data out from the database. Install pyodbc:

	$ pip install pyodbc

Notice when you are using Microsoft Access for visiting the database, the system will automatically generate a ldb file for you.

In Linux, the pyodbc will encouter un-predicted problems, so I use ActivePython in Windows for analyzing the mdb file.

	$ pypm search pyodbc
	$ pypm install pyodbc

Now begin to analyse the database