I have 2 databases, both are located in 2 separate web applications respectively.On one database a i have a table where data is saved, while on the other one in the other database i want to update the data in a certain table when the data is being added on the other table of the other database.how can i achieve this.i am using a tsystem to connect the 2 databases in the env file.i dont have a clue on how to achieve this.help guys
here is my code in the env file of the database where i want to push the data to
TSYSTEM=joans_caspar
MOTHERSHIP_URL=http://steves.my
ONLY_ONE_HOST=false
LOCAL_IPADDR=joans