title: Wordpress development process
body: <p>I want to design a wordpress development process like in following picture:</p>
  
  <p><a href="https://i.stack.imgur.com/fo7Sf.png" rel="noreferrer"><img src="https://i.stack.imgur.com/fo7Sf.png" alt="enter image description here"></a></p>
  
  <p>First I want to create a bitbucket repository for my Wordpress site. From this repository all our software developers should able to clone the site to their local machines for developing. For developing all developers should have one local database to test changes. </p>
  
  <p>After a developer finished a task he should be able to push his changes to the repo. When a sprint is done I want to send all changes from the repo with Jenkins pipeline/job to the test environment. At this environment a tester should be able to test all new functions with a cloned database from the prod system (including the dev changes).</p>
  
  <p>When all tests are successfully done I want be able to apply the database changes to the prod system (with a SQL script) and send all changes with an other Jekins pipeline/job to the prod system. </p>
  
  <p>Do you think this can work? Whats with plugin updates? Can I setup environment variables for each system so the plugin updates can be just done on the dev machine? </p>
  
  <p>I'm not sure if this could work because a plugin or plugin update creates a lot of new database changes and I think I need a tool who can display all changes like Sourcetree for git. </p>
  
  <p>Is there someone who has expert knowledge with wordpress and this kind of development process and can share his experience with me? </p>
  
  <p>Or do you think this process is not working with wordpress? If this is true it would be realy bad because I need a process like this. </p>
  
  <p>Thanks a lot!</p>