I have configured my WordPress site to push updates through SourceTree to a Bitbucket repository, and the Azure Web App Service hosting my code reflects these source changes correctly. However, while code updates appear as expected, the online database remains unaffected when local changes are pushed. The team works locally with a remote database connection. What steps can I take to ensure that the database stays up-to-date?
I experienced a similar issue when trying to synchronize code changes with database updates during deployments. After some trial and error, I realized that the repository and deployment scripts were solely focused on code updates, which meant database changes had to be managed separately. I eventually incorporated a step in the deployment process that ran SQL migrations automatically. This approach allowed for a more seamless integration of database updates with code pushes. It may be worth considering a solution like this to ensure your remote database stays in sync with local changes.