[Sussex] Access migration to MySQL help, please?

[Matt Brown]

On Fri, 2003-02-28 at 17:03, Mark Harrison wrote:
> Hi all,
> 
> A client of mine has agreed to trial a MySQL / Web front end replacement for
> one of their current systems - client contacts.
> 
> They're a small business, and their current marketing database is in Access,
> on the laptop of their marketing guy.
> 
> They're marketing department now consists of three people, all of whom spend
> most of their time in the road or at home, so this is not ideal :-)
> 
> The two options I ran through with them were Notes or Web-based... You'll be
> glad to know they chose web-based, and it's going to run on a MySQL backend.
> 
> What I actually need help with is getting the info from them. Their
> marketing guy is "NON-TECHNICAL", and concerned about just sending me the
> database. I've reassured him that, for the proof of concept, I just need the
> STRUCTURE not the CONTENT.
> 
> I don't actually have any Access experience. Does anyone know if there's an
> easy way to say "make a new exmpty database, based on the structure of this
> one"??? If so, he could do that, and mail me the EMPTY one :-)
> 
> Regards,
> 
> Mark
> 

Ok, maybe worth trying one of these to export the database then just
copy out the sql structure once exported.

http://www.mysql.com/portal/software/convertors/index.html

Regards

Matt Brown