Often when working with various companies they may have an existing database and may require that the existing data be imported from a mysql database to mssql server database. The below article is a good starting point and outlines some points to take into consideration.

MySQL to SQL Server Conversion Tutorial

Useful MIME types for Microsoft Office documents:

You upload a file to your CMS via your rich text box but you get a 404 error.

The solution to this is Internet Information Services (IIS)


Out of the box, IIS6 only accepts requests for known MIME types. Since Office 2007 was released after Windows Server 2003 and IIS6, IIS6 knows nothing about the new MIME types. So you need to manually add them:

    Open Computer Management. (Right-click My Computer… Manage…)
    Right-click Internet Information Services (IIS) Management… Properties…
    Click MIME Types…
    Click New… and add the following:

Recently noticed another first in terms of FTP connectivity with out server. Basically our account was locked out by windows as a security precaution - dont know why this happened but was an easy fix.

Always worth keeping an eye on this as usual i was pulling my hair out.