What is our need:
When a user logs into the app all data written to and retrieved from the database needs to be unique to their tenant.
Where we are now:
Our app is going from the desktop client/server to the web. Data was physically separated by each client location so there was no need to add a specific identifier to their data in the database.
What we've considered:
We've considered unloading the clients' data into a file and then updating the DB tables with a tenant ID or something similar. Then reloading the data and having each user's login credentials connect them to their data and not another clients'.
Is there another option besides the manual process I mentioned above or is it the only one available given the situation? Note, we began looking into dynamically setting the data source with the appeon workarounds.pbl however SQL Anywhere is not supported.
As always, any advice, tips, or suggestions, are appreciated.