Upsizing to MYSQL

[gemma-the-husky]

Starter for TEN required here!

I have temporarily given up with SQLServer, and thought I would try MySQL

I downloaded MySql, (is it really only a command line interface?) and HeidiSql -but I am struggling to identify how to design tables, to upsize an app.

Can I take a Jet/Ace table and insert those fields directly into my new database in MYSql. Or do I have to design every field manually.

(Or can I even just iterate all the table defs, and create all the fields in code)

(also with HeidiSQL - I coudnt see a why of setting a field as auto-increment. Am I missing something there)



[ah - found bullzip now - so I'm going to try that. Any other recommendations]

 

[Banana]

Why not use MySQL's Workbench for GUI interface? The recent release is pretty full-featured.

As for a simple way to import Access table, I'm not aware of any free program that does it- I see few commerical programs offering this but I'm of mind it's best to do it from scratch in MySQL - importing in bulk can hide some problems.

 

[gemma-the-husky]

thanks Banana - after posting, I saw this thread

http://www.access-programmers.co.uk/forums/showthread.php?t=206206

which had some helpful suggestions, including some by yourself.