Body: <p>I need to merge CiviCRM data from a Drupal 6 site into a Drupal 7 site that has an existing CiviCRM installation.
  The sites are running under Aegir. In both cases the Drupal and CiviCRM tables are in the same databases. The D6 site is on Civi 5.24.3 with about 45k contacts with lots of organisation memberships + events records. The D7 site is on Civi 5.25.</p>
  
  <p>I understand that I can do the laborious export/import process but am hoping someone has a recipe for a more efficient way.</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-12T19:11:17.967Z
Comments.Text: so you have data already in the d7 db that need keeping?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-13T20:33:21.267Z
Comments.Text: Hi Pete. The d7 site was set up for a once-off conference and has a small amount of contact and event data. I have already exported the d7 civi data back into the d6 site (so don't need to keep the d7 civi data)
Comments.UserDisplayName: Davy Ivins
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-14T00:14:20.040Z
Comments.Text: so do you now just need to copy the civi db (skip triggers) from the d6 site to a d7 site?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-14T00:14:50.977Z
Comments.Text: ie replace the civi db on the d7 site with the copy from d6?
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-14T14:08:35.847Z
Comments.Text: yes that is correct.
Comments.UserDisplayName: Davy Ivins
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-18T20:47:23.653Z
Comments.Text: If you convert/update the D6 site into a D7 site, can you not then just import / clone the Drupal data/content in the newer site to the former D6/now D7 site?
Comments.UserDisplayName: Joe McLaughlin
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-05-20T09:56:12.260Z
Comments.Text: Thanks Joe. We had hoped to do that but have a bunch of modules with no easy upgrade path. My developer was also hesitant. I'm going to try exporting / importing the Civi tables per Pete's nudge :-)
Comments.UserDisplayName: Davy Ivins
Tags: <drupal><duplicate-contacts><drupal-6>
Title: Merge CiviCRM data from D6 to existing D7 database
ThreadText: # Merge CiviCRM data from D6 to existing D7 database
  
  (Asked by: username_0 on 2020-05-12)
  
  I need to merge CiviCRM data from a Drupal 6 site into a Drupal 7 site that has an existing CiviCRM installation.
  The sites are running under Aegir. In both cases the Drupal and CiviCRM tables are in the same databases. The D6 site is on Civi 5.24.3 with about 45k contacts with lots of organisation memberships + events records. The D7 site is on Civi 5.25.
  
  I understand that I can do the laborious export/import process but am hoping someone has a recipe for a more efficient way.
  
  **Tags:** drupal, duplicate-contacts, drupal-6
  
  > **Comments:**
  > **username_1**: so you have data already in the d7 db that need keeping?  
  > **username_0**: Hi Pete. The d7 site was set up for a once-off conference and has a small amount of contact and event data. I have already exported the d7 civi data back into the d6 site (so don't need to keep the d7 civi data)  
  > **username_1**: so do you now just need to copy the civi db (skip triggers) from the d6 site to a d7 site?  
  > **username_1**: ie replace the civi db on the d7 site with the copy from d6?  
  > **username_0**: yes that is correct.  
  > **username_2**: If you convert/update the D6 site into a D7 site, can you not then just import / clone the Drupal data/content in the newer site to the former D6/now D7 site?  
  > **username_0**: Thanks Joe. We had hoped to do that but have a bunch of modules with no easy upgrade path. My developer was also hesitant. I'm going to try exporting / importing the Civi tables per Pete's nudge :-)  
  
  ---
  
  ## 0 answers
  
  