Web Wiz Forums - Porting Access to mySQL version

Print Page | Close Window

Porting Access to mySQL version

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=24684
Printed Date: 06 April 2026 at 10:20am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Porting Access to mySQL version

Posted By: Gleedo
Subject: Porting Access to mySQL version
Date Posted: 23 October 2007 at 11:00am

Hello.

Can you tell me if it is possible to port data from your access forum database version to a mySQL version forum database?

Kind Regards

Replies:

Posted By: Gleedo
Date Posted: 24 October 2007 at 7:57am

Dont worry, we are just gonna start a fresh mySQL version quite soon :)

Posted By: WebWiz-Bruce
Date Posted: 24 October 2007 at 9:26am

There are tools if you search on Google to do this. However it is trial and error as some people have successfully done this, but others report unstable databases after the migration.

The biggest issue is that mySQL handles dates/times and true/false datatypes completely differently to Access, and in some cases mySQL doesn't have the same datatype type available so the migration tool has to make an educated guess at an alternative datatype.

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