Web Wiz Support and Community Forums : Porting Access to mySQL version https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 10:25:27 +0000 Wed, 24 Oct 2007 09:26:42 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24684 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Porting Access to mySQL version : There are tools if you search...]]> https://forums.webwiz.net/porting-access-to-mysql-version_topic24684_post128696.html#128696 Author: WebWiz-Bruce
Subject: 24684
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.
]]> Wed, 24 Oct 2007 09:26:42 +0000 https://forums.webwiz.net/porting-access-to-mysql-version_topic24684_post128696.html#128696 <![CDATA[Porting Access to mySQL version : Dont worry, we are just gonna...]]> https://forums.webwiz.net/porting-access-to-mysql-version_topic24684_post128695.html#128695 Author: Gleedo
Subject: 24684
Posted: 24 October 2007 at 7:57am

Dont worry, we are just gonna start a fresh mySQL version quite soon :)]]> Wed, 24 Oct 2007 07:57:57 +0000 https://forums.webwiz.net/porting-access-to-mysql-version_topic24684_post128695.html#128695 <![CDATA[Porting Access to mySQL version : Hello. Can you tell me if it...]]> https://forums.webwiz.net/porting-access-to-mysql-version_topic24684_post128672.html#128672 Author: Gleedo
Subject: 24684
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
]]> Tue, 23 Oct 2007 11:00:09 +0000 https://forums.webwiz.net/porting-access-to-mysql-version_topic24684_post128672.html#128672