I am looking for some suggestion.
I have a database on an internal network that is not accessible to the internet. It stores company users from multiple places.
I have a Laravel application that is publicly accessible that has a user’s table. Users can register and create accounts.
What I want to do is pull in specific data from the internal database into the public one and sync it, as necessary. I am thinking that I might be able to create a Laravel application on the internal network that can access the internal database and export it to the external Laravel application over an API connection. Would that be the best way to do it? This would need to be done securely.