3 Replies Latest reply on Apr 7, 2017 6:50 AM by beverly

    Recreate ESS SQL tables as native FM tables in existing solution

    appdev

      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