Web Wiz Forums - Converting from MSSQL to MYSQL

Print Page | Close Window

Converting from MSSQL 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=31594
Printed Date: 29 March 2026 at 7:41am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Converting from MSSQL to MYSQL

Posted By: markomeara
Subject: Converting from MSSQL to MYSQL
Date Posted: 03 January 2019 at 9:04pm

Hi,

I was wondering if anyone has done a recent conversion from MSSQL to MYSQL for the forums database.

I can easily download my MSSQL .bak file and was wondering the best route to converting...

I'm changing hosting companies in the process so it would be easy to take the backup and convert and load into a new database.

I'm planning to use the MYSQL Workbench to do the conversion, but if there are better tools please let me know.

Just wondering if there are any things to watch out for..... or any 'best practices'?

Thanks

Mark

Replies:

Posted By: WebWiz-Bruce
Date Posted: 04 January 2019 at 9:27am

I would highly advise against this as the SQL Server version is not only faster but far more stable than MySQL.

Unless you have absolutely no other choice you should always use the SQL Server version of Web Wiz Forums.

As well as speed and stability issues you will also have other issues as the SQL Server version of Web Wiz Forums uses a Relational Database System, whereas the MySQL version does not.

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