Web Wiz Forums - From MSSQL 2005 Express Editon to MySQL

Print Page | Close Window

From MSSQL 2005 Express Editon to MySQL

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=30125
Printed Date: 31 March 2026 at 4:52pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: From MSSQL 2005 Express Editon to MySQL

Posted By: MarioM
Subject: From MSSQL 2005 Express Editon to MySQL
Date Posted: 22 January 2012 at 5:24pm

Hi

I need change a forum database&hosting and I wonder how migrate my forum from MS SQL2005ExpressEdition to MySQL.
Is there any tool help me to do it?

regards,
MarioM

Replies:

Posted By: WebWiz-Bruce
Date Posted: 23 January 2012 at 11:41am

The SQL Server version uses a Relation Database, while the mySQL version does not.

mySQL also stores dates, bit types, and other data types in different ways to SQL Server.

If you wanted to move from SQL Server to mYSQL version you would need to start again with a clean install.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: markusfromgermany
Date Posted: 31 January 2012 at 8:34pm

I know, Bruce won't support migrating to mySQL from a microsoft database (MSSQL, Access), but there are many people who need this. Why? Starting with Access is the easiest way. Then the forum and community grows and you need to migrate to a bigger system.

So - if Bruce won't to this - perhaps the webwiz community start a guideline for doing this?

I think of starting with a clean mySQL installation - delete the keys - inserting existing data (export from access as excel and import from excel) and setting the keys again?

would this be possible?

Posted By: WebWiz-Bruce
Date Posted: 01 February 2012 at 9:44am

If you start with Access as your forum grows you should upsize the database to SQL Server which is also an RDMS.

We have Web Wiz Forums running on our network with as many as 5 million posts using SQL Server, however we find those that use the mySQL version we often have to move to SQL Server due to database and performance issues at around 300,000 posts.

The myODBC driver required for ASP to talk to a mySQL database is also very buggy, we are forever trying to find work arounds to error caused by this driver. It causes all sorts of stability issues.

Access is fine as a desktop database, mySQL is fine with PHP, but with ASP you should be looking at using SQL Server.

Most web hosts, like ourselves, offer SQL Server as standard with all hosting plans, so it is not that expensive these days to use SQL Server.