Move to SQL method.

Discussion created by malachydevlin on Sep 24, 2015
Latest reply on Sep 24, 2015 by beverly

Hi All,

I have to move some tables to SQL back end and I have good knowledge of this however there is one oddity I would love advice on.

Currently I have 4 interface FM files that all link to a single database FM file.

The 4 files a 4 separate modules but the do share some tables from the main db, especially for value lists etc.


1 - I could re link the fm database file to the ODBC SQL and leave the font end files linking to the FMdatabase file


2 - I could link each of the 4 files directly to the ODBC SQL.


Not sure which would be right or wrong.


I know with option 1 I have only 1 place to manage shadow tables, auto enters etc so that would be my favourite but im worried that piggy backing might slow things down?