I've a rather particular scenario to put forth - I was hoping someone could share similar experiences, or help guide my research.
My current project involves D7, Commerce (Kickstarter), multi-language.
There is an existing site which is live, and I am developing a alternative "new, and improved" version, based on the existing configuration. I started with a copy of the live site, and have developed it further.
I am preparing to deploy my dev version.
The live version will have gained new users and commerce orders, since I last made a copy of its database.
My deployment options seem to be:
A. Deploy my changes (files, media, configuration) to live site
B. Merge live site (users, orders) with dev version, then deploy dev version.
I am leaning towards Opt B
Examples of changes I have made to my dev version -
- installed and uninstalled modules
- created new theme
- converted content types
- reconfigured Views
- introduced custom view modes
- added fields to content types
- populated those fields
- added field collections
- added custom blocks
- created contexts
- content translation
- menu translation
- some Commerce product variation type field display - can easily be recreated manually
I am not too experienced using the Features module and so I am not sure if using it would make it possible to deploy all my changes (as in Opt A), hence my leaning towards Opt B.
I will be developing the dev site more once I deploy this stage, so I will either need to repeat this deployment process or use the Features module going forward, probably with more bite-size changes.
I am not too concerned with the live site's content-related changes, as these have been tracked and can be recreated manually (there aren't many).
I would like the opportunity to explore the database structure in Drupal moreso too, but my understanding is lacking.
I am concerned it's not a simple "export/import users table" - at least, not in relation to commerce, so if I attempt this, I will accidentally omit data.
My specific questions are:
What tables are associated with Drupal users
What tables are associated with Commerce
how would I (or anyone) find this out?
Would doing a db dump from live site and comparing the diff with my dev mysql be informative? Would I be able to add users and commerce entities that way?
Feel free to poke holes in my thought-process and/or deployment options! Maybe there is an option C?
Thanks for any advice, suggestions, direction :)