Title: WordPress cicd database migration
Last modified: February 15, 2022

---

# WordPress cicd database migration

 *  [bespokeeagle](https://wordpress.org/support/users/bespokeeagle/)
 * (@bespokeeagle)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/wordpress-cicd-database-migration/)
 * hello, I am fairly new to developing WordPress and I am wondering the best way
   to migrate the necessary tables in my database.
    I am using a ci process on Azure
   devops to handle the migration of files from local to live. I want to be able
   to update my live the dB and not overwrite it. Does anyone have any suggestions.
   I will like to know how and if this is possible If it is, i do i know the necessary
   tables to migrate.
    -  This topic was modified 4 years, 3 months ago by [Jan Dembowski](https://wordpress.org/support/users/jdembowski/).
      Reason: Moved to Fixing WordPress, this is not an Developing with WordPress
      topic

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [catacaustic](https://wordpress.org/support/users/catacaustic/)
 * (@catacaustic)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/wordpress-cicd-database-migration/#post-15365275)
 * Do you mean that you want to update your live sites database with anything that’s
   been updated on your dev site without changing anything that shouldn’t be changed
   on your live site?
 * If that’s the case, you really won’t be able to do that. There’s no good tool
   or process available that can handle SQL queries to let you merge and update 
   like that. There’s been many projects to try and make one, but so far nothing
   has come close to working correctly.
 * The best thing to do is get your dev sites database to a point where it’s everything
   that you need it to be, and transfer that over to overwrite your live sites database,
   or go through your live site and make updates as needed to match the dev site.
 *  Thread Starter [bespokeeagle](https://wordpress.org/support/users/bespokeeagle/)
 * (@bespokeeagle)
 * [4 years, 3 months ago](https://wordpress.org/support/topic/wordpress-cicd-database-migration/#post-15366309)
 * [@catacaustic](https://wordpress.org/support/users/catacaustic/) thanks for the
   response i will look into that.
 * I’m just worried about GDPR regulations concerning user data on dev and staging
   environments

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘WordPress cicd database migration’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [migration](https://wordpress.org/support/topic-tag/migration/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [bespokeeagle](https://wordpress.org/support/users/bespokeeagle/)
 * Last activity: [4 years, 3 months ago](https://wordpress.org/support/topic/wordpress-cicd-database-migration/#post-15366309)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics