WPDA: Changes management & Version control – Best Practices

Hi @rladha,

Good question! 🙂

1. How to deploy a single or multiple field change(s) from DEV to Prod?

That depends on how you are developing. If you are writing your own scripts, you can just run your own alter table scripts. If you are using the Data Designer, the Data Designer can create an alter table scripts for you. The plugin however, does not save these scripts, so you would need to save them manually and run on the production server.

2. How to deploy a new page from DEV, QA, to Prod?

After updating the database, you can copy your new version of a publication or project to your production server. But you would need to remove the old version first. After that you will need to change the ID’s used in projects and publications.

This mechanism is not yet very smooth. It needs to be polished. I have just released the Code Manager, which allows to use code names instead of code id. The implementation of this mechanism into WP Data Access is on my to do list. And imports need to perform updates instead of inserts only.

Does this answer your question?

Best regards,
Peter