Title: Duplicator and Changing Database
Last modified: February 10, 2024

---

# Duplicator and Changing Database

 *  Resolved [paulpledge](https://wordpress.org/support/users/paulpledge/)
 * (@paulpledge)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/duplicator-and-changing-database/)
 * Hi. I use Duplicator to create development copies of our live site. Works brilliantly
   except that wp data access table publisher databases do not get pointed to the
   new database. I read this post: [https://wordpress.org/support/topic/changing-the-database-schema/](https://wordpress.org/support/topic/changing-the-database-schema/)
   which seemed to suggest exporting and importing, I assumed exporting from the
   live one and importing into the development one. But this seems to fail if the
   published table already exists or creates a new one with a different ID/shortcut.
   Could you clarify the best way to do this. Thanks

Viewing 1 replies (of 1 total)

 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [2 years, 3 months ago](https://wordpress.org/support/topic/duplicator-and-changing-database/#post-17418809)
 * Hi [@paulpledge](https://wordpress.org/support/users/paulpledge/),
 * We have a SQL procedure to help with proper schema migration between site movements.
   😊
 * The process is outlined here: [https://wpdataaccess.com/docs/data-explorer-problems-and-solutions/transfer-to-other-wordpress-database/](https://wpdataaccess.com/docs/data-explorer-problems-and-solutions/transfer-to-other-wordpress-database/)
 * Hope that helps! Let us know if you need anything else.

Viewing 1 replies (of 1 total)

The topic ‘Duplicator and Changing Database’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Kim L](https://wordpress.org/support/users/kimmyx/)
 * Last activity: [2 years, 3 months ago](https://wordpress.org/support/topic/duplicator-and-changing-database/#post-17418809)
 * Status: resolved