Re: Database / Table design
Posted by: Peter Brawley
Date: April 12, 2021 11:10AM

Private help is usually a commercial arrangement.

To get help via the forum, I'd start by modelling the existing Access DB, either in Access itself or with one of many available open source modelling tools.

Then I'd install MySQL, work through its tutorials, then write a new design for the DB from ground up following a method like https://www.artfulsoftware.com/dbdesignbasics.html, using MySQL WorkBench to build the model.

When that's done, I'd write a script that maps and copies the old DB to the new DB.

That's the cleanest way. The alternative is to port the Access DB straight to MySQL, then fix it. Often that turns out to be a lot harder than it sounds---because the problems in the old design don't map easily to a relational model.

Options: ReplyQuote


Subject
Written By
Posted
April 12, 2021 03:36AM
Re: Database / Table design
April 12, 2021 11:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.