The magento 2.2 documentation, in its Pipeline Deployment Overview , states the following (brackets & emphasis mine):
[the production system is] Your live store. You should make minimal configuration changes here and no changes to websites, stores, store views, products, or the catalog. You should make all those types of changes in your development system.
I totally agree with that statement.
After making and testing such changes on development store, how do I get those changes onto production?
Is there a best practice, or at least a recommended approach to this? I appreciate any help/insight.
For instance, are there a selection of tables for which I can write a migration script to safely execute each time I need to push content/catalog changes to production?