09 03 27
My provider is space1.nl. Because it is CHEAP and this blog is an exercise and demonstration of Open Source and migration.
I get ASP.NET 2.0 hosting from this provider with (among others) a MySQL backend. Because this backend isn't always super-friendly to me (as I am primarily a SQL Sever developer), I chose BlogEngine.NET as an engine because:
- Flat file option is default
- MySQL backend is an option
- SQL Server is an option
This means I can deploy to 'production' (www.tobiasopdenbrouw.nl) running flat-file (which it is at time of writing) and update the 'development' side (this subdomain) to MySQL for now (which has just happened). I can move to SQL Server, if I like, later, if I need to hook it to more powerful dev tools.
I ran into some minor issues, and fixed them, and later ran into a page by codecarnage that helps people out with some of the same issues.
One of things not provided in that instruction is a re-write of the sql install script with proper cases. I have re-written the MySQL Install script to use correct upper cases for the tablecreates and some other, later, queries.
Let me know if you want this script.