Re: [cobalt-users] What databases does the ChilliSoft ASP support?

["Steven Werby" <steven-lists@xxxxxxxxxxxx>]

Frederik Wille <frederik.wille@xxxxxxxxx> wrote:
> Another question, is it possible to migrate an acces database to an mysql
> database?

Migrating from Access to MySQL is trivial.  Dump the output of your Access
tables into a CSV text format or some other delimited format.  Then use MySQL's
LOAD DATA SQL statement or its included program "mysqlimport".

> Where can I find some more information about this?

http://www.mysql.com/  Be sure to check for differences between MySQL and
Access.  Access supports referential integrity; MySQL does not.  There are
probably some other subtle differences that may affect your migration, but I
doubt you'll run into anything major.

--
Steven Werby {steven-lists@xxxxxxxxxxxx}