WordPress Staging Site

I fear that there does not exist an answer that is going to make you happy. There is no (easy/good) solution for this problem. In most cases, the production (staging) environment does only touch the code (FTP-files) of a WordPress website, while the live version makes changes to the database (e.g. adding content to it). So normally, when you want to update the live version, you (Git) pull the new version of the website onto the server, and do not touch the database. Additionally, one could change some minor settings within WordPress manually, which will update the database.

However, in the particular case you describe, using Page Builder to develop new features/pages on the staging website, both the staging version and the live variant of the website are making changes to the database.

As far as I know, the only method to update the live website is to find out which database records are updated by Page Builder and add these to the live database manually. The only ‘real’ solution that I would know of is to create new features in the code itself, but I can see how this might not be a solution for you.

TL;DR: both variants (stage/live) make changes to the database, they have to be merged which is not trivial.

Related Posts:

  1. How to: Easily Move a WordPress Install from Development to Production?
  2. Database synchronization between dev/staging and production
  3. WordPress database synch between dev and prod
  4. Maintaining synced staging/production WP sites
  5. How do you add pages on a staging server, and then move them over to production
  6. What actions affect files, DB, or both?
  7. How to Work Seamlessly Between Development, Staging, and Production Sites in wordpress
  8. How to sync staging to production but keep plugin settings
  9. Ways of managing staging and production wordpress sites?
  10. Most Flawless Way To Transfer from Dev to Prod [duplicate]
  11. Migrate Changes from a Staging Site to Production
  12. Staging a WordPress site with WP-Deploy
  13. Syncing production with staging
  14. How to run a test WordPressMu to WordPress3 update?
  15. Different color admin bars for dev, staging and production
  16. Merging WordPress posts from different databases
  17. Using second site as staging area
  18. Override database config for WordPress multiblog
  19. Child theme works in local environment but is not working on remote
  20. Staging environment for pages only
  21. Multiple users working on WordPress admin at the same time [closed]
  22. WordPress & WooCommerce: Localhost, Staging and production environments and how to sync them without losing data
  23. Published site reverts without changes to theme
  24. Localhost to Staging to Development Dynamic WP-CONFIG
  25. Setup 3 Sites To Connect To 1 Database and Share Data
  26. Staging only for Theme Files and Changes
  27. Redirect to another page using contact form 7? [closed]
  28. Staging Sites: What to push through?
  29. What are some tools for password protecting a staging site?
  30. Publishing WordPress from stage to production server
  31. How do you keep your live and and testing server?
  32. production site routes to staging site after cloning
  33. How to clean up the theme for production?
  34. Push from staging to live site?
  35. Staging site offline
  36. Merging new theme and plugins from development site to production
  37. Locked out when attempting a migratoin
  38. Creating WordPress staging environment software
  39. how to move particular functionality to staging server
  40. Theme/Plugin/Widget Data and Staging/Production Servers
  41. Graphic design changes on Staging before moving to Production?
  42. How do I set up a test environment in a sub-folder?
  43. Staging/production deployment on WordPress MultiSite
  44. How to set up a development/staging site to make major changes to the theme then update on the live site?
  45. Is there any other ways to replicating changes on live from staging without pushing from git
  46. Where do I build my updated website?
  47. Remove WordPress theme from a specific page
  48. How to keep a WordPress site synchronized between two servers?
  49. Integrating WordPress to my website, while keeping my own authentication system
  50. How to delete outdated, wrongly sized images in _wp_attachment_metadata?
  51. Custom Fields and performance
  52. How to show custom message once on plugin activation?
  53. One WordPress Install, Two Categories. Each Category Gets a Domain
  54. Query post types with multiple keys
  55. What is the canonical way to link to pages?
  56. Defer Code in Widgets – Page Speed
  57. How to add default images into theme customizer image control?
  58. Best practices: Custom theme sidebar menu – hardcode or widget?
  59. Why would switch_to_blog stop working?
  60. How to make new plugin setting checkbox default as checked
  61. ‘Customize’ button in admin bar for CSS
  62. Fatal error: Call to a member function add_rewrite_tag() on a non-object in /wp-includes/taxonomy.php on line 333
  63. Change login error messages? Cookie error message
  64. Custom Page that comes with preloaded content for the user
  65. Allow non-admins to access the Customize theme page
  66. Query post for ‘selected category’ in archive.php
  67. Multiple Images/ Slider with custom post [single.php] [closed]
  68. Best practices to assert current_user_can() with guests
  69. Insert image in WordPress with HTML5 tag and caption function
  70. Best Practices for a Completely Customizable Homepage – without plugins
  71. Localization: I want the backend: english and frontend in defined language
  72. Theme compression/ minifying or W3 Total Cache – which should I use? [closed]
  73. How to check for images before echo
  74. How to make universal gallery and improve admin side of managing galleries?
  75. Need ‘logo page’ before wordpress page!
  76. Sticky menu for WP custom menubars
  77. When I try to de-activate any plugin it gives error “Warning: call_user_func_array() [function.call-user-func-array]”
  78. How can style text like this in wordpress
  79. Setup database structure with books, authors, languages etc. for publishing house [closed]
  80. Help customising admin bar, removing buddypress links from dropdown
  81. Action on WordPress Install
  82. WordPress in a Subdirectory
  83. What is the best way to make a custom page from a plugin?
  84. javascript file not working in a plugin template file
  85. How do I know if the user is a customer?
  86. Add button to My Sites dashboard page (multisite)?
  87. A specific menu inside a page, load different contents without reloading it, under the same link
  88. How to use custom footer template in a site-plugin?
  89. Add Categories To Custom Post
  90. How to define a static Home page
  91. Remove all link title attributes
  92. Custom Single Post Type not referring to single-post-type.php File
  93. how to display wordpress navbar with top menu outside wordpress system
  94. Change the search results header from plugin
  95. Make Terms Under Custom Taxonomy Use Specific Single.php Template
  96. Problem Locating and Changing Alt Attribute Of Link
  97. URL to an image in a post is changing when permalink is set to custom. Can I avoid this?
  98. Img alt tag showing different value then entered
  99. Custom Post want button to add image and save in Postmeta
  100. Product customizing quiz – quiz adding products to the cart