Hi,
I have 3 client tables I would like to merge into a single one in the central server.
Those client tables won't have conflicting PK, and can only insert data.
I thought of federated tables, but network sortages really ARE an issue, so I dismissed it. The approach should be able to store data locally, but send it to the server when available, and the server would store it altogether in a single table.
What would be the best approach to it?
Thank you