Hmm, tricky problem apparently

My idea for solving this would be to set up another site at home with MySQL and configure all standard settings and so on manually. Copy all files including images, documents etc. and then (with help from a friend who is a DB Guru) to write a script that dumps content from the MSSQL-DB and another one that imports it into the MySQL-DB if that is possible.

Of course some things cannot be imported/exported, but I guess most content can at least. I could make the site structure with blank pages manually, but I need documentation about the database structures, table names and so on and some hints. Can I find all this within the developer documentation?

If I am successful with this, of course the migration scripts will be made available to the community. Or is a migration utility something that should go into "Feature Requests" instead?

Br
/Mats

Arrgh!

Ok, just to roll up the sleeves and recreate the site from scratch and a lot of copying-pasting . It is only about 80 pages with a few contents on each page... No immediate hurry, so I do it an hour now and then during this week.

It is a perfect oppurtunity to clean up and also to switch to extensionless urls. In order to have links on other sites that point into my site to continue working I use the 301 redirect manager to redirect to the the old urls. In most cases these are the same but now without the .aspx extension.

However, it is a tedious task to enter each one in manually. Is there a way to implement "wildcards" for this so that every referral to a ".aspx"-page is redirected to its extensionless counterpart. I understand that this might lead to some problems for admin-pages and so on, but all of them are in subdirectories so it would be possible. I have created friendly urls for "/login"->"/secure/login.aspx" and so on.

(Redirect "/*.aspx" to "/*" did not work ;))

/Mats

Use a tool to migrate database from mssql to mysql database, i use dbload for the conversion of database.

Find Here : http://www.dbload.com