AnsweredAssumed Answered

What is the best way to display records from one database to another

Question asked by ThierryGuemboura on Mar 31, 2018
Latest reply on Apr 2, 2018 by ThierryGuemboura

I have a big database running smoothly internally (FM Server 16 with 15 users). Some clients have expressed the desire to see their files. I recently hosted the whole file on the cloud but it was too slow for my users so I drop the idea to host everything. Now, I am trying to find another solution. My idea is to design a second database which will be hosted as WebDirect. I would use the External Data Source to link the two DBs. Would you recreate on DB2 the needed layouts and display data through relationships or import records by scripts from DB1 to DB2 or lookup records or do something else?