2

It sounds like you have quite a mission. There is no smooth path for synching between the two. We have tried building such a process but it was not robust enough to release. Our general approach is that if anything is created on live then replicate it on dev, and do not create anything on dev without having first created it on live. This is the only way ...


2

So a few things, if you turn on logging then you'll get a full timestamped history of changes to all tables in the database. If you had this on both environments then you would now be able to see all the changes. However what your describing is a workflow issue, i.e. having changes happening in two environments without being clear on how changes will be ...


2

I have not tried this but https://lab.civicrm.org/extensions/configitems says The extension can import the following types of items: ContactTypes MembershipTypes RelationshipTypes OptionGroups with OptionValues Groups Tags FinancialAccounts FinancialTypes EventTypes ActivityTypes LocationTypes CaseTypes CustomGroups with CustomFields CiviCRM Settings (...


2

To address some of the specific concerns: First - check out hook_civicrm_managed and the *.mgd.php file format in the dev docs. A lot of changes made in the db can be made in code instead and easily moved between sites. Added/edited reports can be moved to an extension. A corresponding .mgd.php file will ensure the report is added to the db. See Extended ...


2

As with the others, I don't know of any great way to sort out the current situation easily, or an out of the box way to make it work super smoothly in the future although of course it does become somewhat smoother if you plan around this from the start when doing your changes. As far as doing this again in the future or "what to do differently next time", ...


1

I have not tried this but https://lab.civicrm.org/extensions/configitems says The extension can import the following types of items: ContactTypes MembershipTypes RelationshipTypes OptionGroups with OptionValues Groups Tags FinancialAccounts FinancialTypes EventTypes ActivityTypes LocationTypes CaseTypes CustomGroups with CustomFields CiviCRM Settings (...


1

As Pete & Parvez have already said, there is no general solution for syncing two systems as you describe. It depends quite what changes you have been making but some of your difficulties can be eased by packaging your enhancements as extensions. There are plenty of examples of extensions creating and using custom fields, tables, reports etc in a ...


Only top voted, non community-wiki answers of a minimum length are eligible