By yarthesh on

Need a advise in drupal 7 migration.

We have developed a site using drupal 7. Now we finished with the first stage of development and need to start second stage. Now when we develop second stage, after completion of every section( there are 7 different section), we need to merge the database with live site.
For this purpose we have research in drupal 7 and find some useful modules like backup and migrate, node export, view data export, features. But as we need to merge the database I think backup and migrate will not work for us as it will replace whole table and every data. We are trying features module but it will not work with custom profile fields and user data. same things with other two module as well.
So can you please able to guide me on this in which I need to merge Views, CCK, Roles, Webform, Menu, Content, User Profile and Users data between live and development website.

Thanks for your time in reading this mail. It will be really helpful if you give some path for resolving above thing.

Thanks & Regards,
yarthesh acharya

⋅ Categories: Drupal 7.x

Comments

john_b’s picture

john_b commented

Everyone has this problem and Drupal shops have evolved their own ways of handling it.

There are modules for migrating content but they probably require too much work and testing to be suitable for a dev-staging-production workflow. They are more useful for migrating content from another CMS or from Drupal (on the basis that a migration is usually preferred to the near-insoluble problems of a major version upgrade). http://drupal.org/project/migrate_d2d

Modules like cTools, Features, Features Extra, Block Export, Strongarm (for exporting variables) are widely used to export settings to code to create a workflow.

Generally there is no easy safe way to merge databases AFAIK, but handling a migration on a very high traffic site is discussed here:
http://denver2012.drupal.org/program/sessions/changing-tires-60-mph-how-...

Deploy module is for staging content http://drupal.org/project/deploy

There are attempts to make things better in Drupal 8 http://groups.drupal.org/build-systems-change-management/cmi

And to bring things right up to date, there is a new Australian product for improving Drupal workflow http://www.technocrat.com.au/products/flower-enterprise-drupal-workflow but it is a commercial product, if they are sharing code I am not aware of it.

Digit Professionals specialising in Drupal, WordPress & CiviCRM support for publishers in non-profit and related sectors