Being a historical LAMP guy, the first problem is how do I get my data across?
The release of free SQLServer Express 2008, with the integration with Vista x64, PHP and Visual Studio is an attractive proposition. But: schema and data first.
This is the ugly part. There were four main changes:
SQLCMD is the command line interface to your SQLServer instance.
Simply typing SQLCMD –S MAJORSTAR\SQLExpress -E -i export.sql
Where SQLExpress is the instance on a machine called MAJORSTAR, -E to login with my current credentials and -i to run the export.sql file.
With further research, the -d (to set db name) and other like tweaking, the amount of editing as completed in step 2 could have been avoided.
In a few short steps, I had imported my schema and data into SQLServer Express 2008
For more indepth articles, The Guide to Migrating from MySQL to SQL Server 2005 looks informative