Our organization has bought a template that we like, and experimented with it, but now that we are ready to install it over our existing site, we find that much, if not most, of the design elements are embodied in the "sample data". The catch is that installing the sample data involves using "snapshot" and "demonstration site" module, and this would delete all existing content on our site - not good! It uses views, panels, chaos tools, flex slider, etc.
The sample data contains a whole lot of design (e.g. 64 blocks in the new template, many views, many panels, sliders, etc.). When I install the theme and the additional modules on our site, I find I still have many hours of work to do to define all the views, slideshows, etc. that I would have expected to "just show up" when I installed the new theme
and activated it. After beating my head against this for a day or so, I now realize that what the developer didn't give me was a database update script that would add these objects to the database for me. Does anyone have an idea how I can proceed? I know I can just go and repeat all the design details that are "in there" in the demo site, but I'm finding that I don't even know what all I need to add. I've jumped into phpMyAdmin and looked at the tables in the demo site and at least there I can see what db items I might need to add, but it's a long process.
Are there some clever things I can do to find the "difference" between two databases? I would install the new theme to a brand new site, without sample data. I would then add the sample data, I would do a database-delta, and then those changes could be applied to my operational site.
Yes I know I'm dreaming, but possibly there's some way out of this short of repeating all the work?