By emilorol on

Hi,

I have 3 drupal sites. 2 of the drupal sites are public site (.com site), the third one is an internal site behind a firewall. The site behind the firewall runs in Linux and MySQL, but pull data from the office MS-SQL and create nodes from it. The questions is:

How can I update the other 2 drupal sites content from the office drupal site?

Note: I might not need all the same fields in the public sites as in the internal one. I would like to have a setup that not only push the content to the two external sites, but if the internal site update a node, to have its content update in the external sites as well.

Thank you.

⋅ Categories: Drupal 6.x, Drupal 7.x

Comments

wouters_f’s picture

wouters_f commented

I am also interested in this topic.
There are many possibilities
Some of them are explained on this site:
http://www.delawarewebdesigner.com/tech-stuff/sync-drupal-content-using-...
Is there no UI for this?

Add me on linkedin:
http://be.linkedin.com/in/woutersfrederik

jan_v’s picture

jan_v commented

Have a look at Services.

This module allows you to get / insert / update / delete drupal content from an external drupal installation by using amfphp, xml-rpc or other service formats.

You could create a custom service php-script that fetches nodes from other databases and syncs them with your drupal content.

ronsnow’s picture

ronsnow commented

One of my clients has a similar situation/need. A production internal site (behind a firewall) where there is a need to publish selected content to public facing site. The public facing site has only a subset of content. In this environment there is a strict firewall policy in place and the two sites can not 'see' each other.

Additional issues:

  1. Public site might have additional content (that might not be on the internal)
  2. Public Comments Considerations: to merge them back to internal or not
  3. Public site based forums - same issue as above
  4. Authorizing of internal content to be selected for public site publishing (migration)
  5. De-Authorizing content on the internal site so that it is removed from the public site
  6. The automation, scheduling, and staging issues - use of a 3rd (shared) domain for staging?