appdev

Recreate ESS SQL tables as native FM tables in existing solution

Discussion created by appdev on Apr 7, 2017
Latest reply on Apr 7, 2017 by beverly

I have a pretty good idea how this will go (not well ) , but wanted to check if someone has done this previously and knew of any tricks.

 

Existing solution was mapped to a bunch of ESS SQL tables and we are now looking to move those tables/data back into FM's native table/field structure.

 

Ideas/unknowns:

- Export a .mer file to get data and headers out of SQL tables and then somehow use first row to generate field names in new native FM table

- if I could somehow preserve the field order, then when I reassign all of the existing map points to use the local tables will the field references (layouts,scripts) line up

Outcomes