Title: Dev -> UAT – PROD deployments
Last modified: October 12, 2020

---

# Dev -> UAT – PROD deployments

 *  [bizmatebiz](https://wordpress.org/support/users/bizmatebiz/)
 * (@bizmatebiz)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/dev-uat-prod-deployments/)
 * **PREFACE**
 * One of the most difficult approach to using WordPress and WooCommerce as an advanced
   environment is how to handle deployments considering that WooCommerce/Wordpress
   are all made of the following features
 * – code base, plugins are added statically. VIP already provides/suggests a way
   to import plugins using composer instead so they dont need to be committed, with
   thousands of files and vendor folders in git
    – configuration: plugin /site configuration
   is in the db, often this cannot be easily separated as it could store configuration
   in wp_options or in custom tables – ensure transaction/customer data is separated
   and protected. I.e. using the sledge hammer approach of copying SQL files from
   prod to local does carry all personal, user, transaction (for instance for WooCommerce)
   information. Obviously copying all this data could cause legal trouble and data
   loss.
 * **REQUIREMENT**
    Based on the preface, and any other aspect pertaining to your
   experience, could you suggest how you handle local -> UAT -> PREPROD -> PROD 
   deployements? making sure you dont have to sync data from prod to dev and without
   any manual workaround? For instance I am planning to run my local dev.site.com
   TO UAT –
 * At the moment I am
    1. doing a git archive of the code and deploy on UAT
    2. sql dump with string replace of domain name to map destination domain, deployment
       of this on UAT
    3. rsynch assets from uploads to UAT
 * Obviously with this approach I cannot deploy to live as it will delete all the
   transactional information, users etc being created on the WooCommerce site.
 * Then how to
    1. plugins/site configuration: but how to upload just the data for plugins and 
       configuration without affecting customer or product data?
    2. ensure customer, previous data is not corrupted, for instance orders and users
 * If you have a strategy could you please share?

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

 *  Plugin Support [Riaan K.](https://wordpress.org/support/users/riaanknoetze/)
 * (@riaanknoetze)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/dev-uat-prod-deployments/#post-13526694)
 * Hi there,
 * If I understand correctly, you’re essentially looking for a method to selectively
   migrate data between environments – right? Assuming that’s correct, the following
   will come in handy: [https://deliciousbrains.com/wp-migrate-db-pro/](https://deliciousbrains.com/wp-migrate-db-pro/)
 *  Thread Starter [bizmatebiz](https://wordpress.org/support/users/bizmatebiz/)
 * (@bizmatebiz)
 * [5 years, 8 months ago](https://wordpress.org/support/topic/dev-uat-prod-deployments/#post-13533019)
 * hi [@riaanknoetze](https://wordpress.org/support/users/riaanknoetze/)
 * Thank you for the suggestion. This plugin or similar are not providing a solution
   unless you know the underlying architecture … ie they are based on selecting 
   certain tables … so you need to know what tables to select.
 * In this respect how does one achieve the goal of a safe migration?
    Do i need
   to dig each single plugin, reverse engineer it and decide what to copy?
 * I dont really need a plugin for table dumping or selective table dumping as this
   is what I am doing already. I guess one needs its own solution in this case as
   WooCommerce/Wordpress status quo is to just use a domain and set everything on
   a single environment.

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

The topic ‘Dev -> UAT – PROD deployments’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504)
 * [WooCommerce](https://wordpress.org/plugins/woocommerce/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [bizmatebiz](https://wordpress.org/support/users/bizmatebiz/)
 * Last activity: [5 years, 8 months ago](https://wordpress.org/support/topic/dev-uat-prod-deployments/#post-13533019)
 * Status: not resolved