Migrating Table From FM9 To MySQL

[Micah G]

I was wondering if it is possible to migrate a table from FM9 to MySQL with minimal effort in FM. This table has over 300 fields and a lot of relationships. The purpose of this is to normalize the data in the table without rewriting the whole FM app. Can I create a view in MySQL that matches the order and names of the fields in FM and replace the FM table with a MySQL View?

What steps are needed to make this work in FM?

[elo]

Not 100% sure what you are trying to achieve, but I suspect there is not going to be an easy automagic way to swap the table occurrence (TOs) of all relationships from CurrentFMTable to ESSMYSQLTableNamedCurrentFMTable...

[Micah G]

Due to the whole system being tied into the structure of an unwieldy non-normalized table, I felt it would be easier to migrate the FM system piece by piece while allowing non-FM development to continue with a fully normalized data structure. I wanted to present a MySQL view of the de-normalized data so the FM system would function as before.

[elo]

Micah still not sure what you are asking.

Just to give a non-ESS example, if you have a table tBigTable that is part of lots of table occurrences (TOs) in the data diagram, even if you just create tNewSmallerTable right in FMPro there isn't going to be a tremendously easy way to "swap" everything pointing to tBigTable to tNewSmallerTable easily and "giving it the same name" doesn't help.

So, any way you dice it, you are going to have some FM work to clean things up when you start normalizing your data.

[Micah G]

Repointing table relationships is fine. I'm more worried about scripts and layouts than resetting the relationships. Can we rename an existing table and replace it with a MySQL view of the same name, reset the relationships and have everything work like before?

[elo]

Not to my knowledge.