Title: Incorporating Database Schema Changes
Last modified: September 29, 2023

---

# Incorporating Database Schema Changes

 *  Resolved [donkiely](https://wordpress.org/support/users/donkiely/)
 * (@donkiely)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/incorporating-database-schema-changes/)
 * After creating a few data forms and project templates, I’ve discovered that I
   need to make a few changes to the database schema, specifically to add a few 
   virtual generated columns. (There isn’t a way to do this in WPDA, right? I’ve
   not seen a way, but I’m not totally up on the plugin yet.)
   After I add those 
   generated columns in the MySQL database, what do I need to do to incorporate 
   the changes into the WPDA objects? I’ve seen references to exporting and importing
   templates and projects (such as [here](https://wordpress.org/support/topic/changing-the-database-schema/)),
   but that seems to be for redirecting to use a different database that has the
   same structure. Or will that re-import the schema with the changes? I’m guessing
   not.Any suggestions?I have to say, the more I learn about WPDA the more I love
   it. Very impressive piece of work!

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

 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/incorporating-database-schema-changes/#post-17087336)
 * Hi [@donkiely](https://wordpress.org/support/users/donkiely/),
 * Thanks for the post! Are you currently connecting to a remote database or is 
   this a database created locally alongside your WordPress database?
 * If you’re connecting [remotely](https://wpdataaccess.com/docs/remote-connection-wizard/remote-connection-wizard/),
   any new tables created in your remote database should also appear in your Data
   Explorer.
 * You can also message us at [Contact | WP Data Access](https://wpdataaccess.com/contact/)
   if you wish to add more information privately.
 * Let us know if you have more questions! 😊
 *  Thread Starter [donkiely](https://wordpress.org/support/users/donkiely/)
 * (@donkiely)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/incorporating-database-schema-changes/#post-17107466)
 * Thanks, Kim! To clarify, yes, this is a remote database. But I’m not concerned
   about Data Explorer. I’m asking about the objects I create from the database:
   projects and templates. When I add the virtual generated columns, what will I
   have to do to incorporate them into my existing objects? Again, _not_ the Data
   Explorer.
 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [2 years, 8 months ago](https://wordpress.org/support/topic/incorporating-database-schema-changes/#post-17109477)
 * Hi [@donkiely](https://wordpress.org/support/users/donkiely/),
 * Thanks for the response! I asked Peter about your question, please see his response
   below:
 * > When the data structure of a table changes, the users just needs to open the
   > project template, go to tab reconcile and perform a reconciliation. This is
   > documented here:
   > [https://wpdataaccess.com/docs/data-apps-templates/reconcile/](https://wpdataaccess.com/docs/data-apps-templates/reconcile/)
   > When the user enabled keep options, all current settings will be saved. Only
   > column that are deleted will be removed.
 * Hope this helps! Let us know if you have more questions. 😊
 *  Thread Starter [donkiely](https://wordpress.org/support/users/donkiely/)
 * (@donkiely)
 * [2 years, 7 months ago](https://wordpress.org/support/topic/incorporating-database-schema-changes/#post-17125577)
 * Thanks, Kim! Yes, that clarifies it perfectly. I just got done adding the virtual
   generated columns and reconciling the affected project templates. And it worked
   beautifully, without affecting any other settings.
 * It’s about time that I head over and give WP Data Access a 5-star review, which
   I’ll do now. It and you all are awesome!
    -  This reply was modified 2 years, 7 months ago by [donkiely](https://wordpress.org/support/users/donkiely/).
 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [2 years, 7 months ago](https://wordpress.org/support/topic/incorporating-database-schema-changes/#post-17125701)
 * Hi [@donkiely](https://wordpress.org/support/users/donkiely/),
 * Glad that worked! Thanks so much for leaving a review! 🤗
 * Have a great day!

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

The topic ‘Incorporating Database Schema Changes’ 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/)

 * 5 replies
 * 2 participants
 * Last reply from: [Kim L](https://wordpress.org/support/users/kimmyx/)
 * Last activity: [2 years, 7 months ago](https://wordpress.org/support/topic/incorporating-database-schema-changes/#post-17125701)
 * Status: resolved