Web Wiz Forums - MS SQL to mySQL

Print Page | Close Window

MS SQL 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=28111
Printed Date: 01 April 2026 at 11:52am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: MS SQL to mySQL

Posted By: MortiOli
Subject: MS SQL to mySQL
Date Posted: 07 December 2009 at 2:52pm

Hi Bruce,

I currently run a WWF with an SQL backend (www.ckyalliance.co.uk), however I would like to look into how I would migrate from SQL to mySQL.

I am looking at moving to another host, but unfortunately they do not offer MS SQL databases, only mySQL.

I am aware that there's been performance issues running WWF with a mySQL backend, but my forum isn't very busy and never under load.

Please could you advise on the best ways of migrating to mySQL, so I can test it out and see if I find any issues?

Many thanks,

Oli

Replies:

Posted By: WebWiz-Bruce
Date Posted: 07 December 2009 at 3:05pm

This would not be simple at all. You would need to search for a migration tool that can do it for you.

However the data types between mySQL and SQL Server are very different so you would need to go through and correct lots of parts of the database.

The last time I did this (and I know the database inside out) it took from 11am till 4pm to get the database converted correctly and the software to do the conversion cost $299

I would not recommend that you do this, instead look for a host that does do SQL Server as mySQL is for PHP and never runs well with ASP/ASP.NET where you should use SQL Server.

Our own Hosting comes with SQL Server 2008 and prices for forum only hosting start at £3.99 and for full website hosting which you can host two full websites on at £6.99.

http://www.webwiz.net/webhosting/" rel="nofollow - http://www.webwiz.net/webhosting/

We also have Unlimited Website/Account Reseller Packages Starting from just £19.99 per month and come with 5 SQL Server databases.

-------------
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