CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • Database portability
Pages: [1]

Author Topic: Database portability  (Read 2174 times)

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Database portability
January 12, 2012, 02:00:44 am
I'm working with a client that is aiming at a live Worpress implementation of CiviCRM in the coming short while. As par tof our preparative work we ar eusing a CiviCRM install sitting alongside Drupal. My question is this: When version 4.1 is out of beta and stnadardised across all three CMS platforms, are the databases totally interchangeable, in that it would be possible to use the method set out at http://wiki.civicrm.org/confluence/display/CRMDOC40/Moving+an+Existing+Installation+to+a+New+Server+or+Location to move a CiviCRM db form a 4.1 Drupal install across to a 4.1 Wordpress install?

And if the answer to that question is no, can anyone advise on the best approach to achieve this migration.

Thanks
Graham
Graham Mitchell
http://mc3.coop

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Database portability
January 12, 2012, 03:50:33 am
Hi,

It should mostly work, but one problem is going to be the table that link the CMS user and the contact in civi. (assuming you won't have the same id in wordpress & drupal).

This being said, I'd test on a dev site (and I'd do it sooner than later even if beta)
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: Database portability
January 12, 2012, 04:01:59 am
Thanks Xavier. At this stage I'm not concerned about CMS users, so I imagine that we can manually edit the table post migration and then do a user synch once hooked in to WP. I'll certainly run a trial and feed back anything I find - or come back with questions if/when I get stuck  ;)
Graham Mitchell
http://mc3.coop

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Database portability
January 12, 2012, 11:46:08 am
Quote from: Upperholme on January 12, 2012, 02:00:44 am
When version 4.1 is out of beta and stnadardised across all three CMS platforms, are the databases totally interchangeable, in that it would be possible to use the method set out at http://wiki.civicrm.org/confluence/display/CRMDOC40/Moving+an+Existing+Installation+to+a+New+Server+or+Location to move a CiviCRM db form a 4.1 Drupal install across to a 4.1 Wordpress install?

It would appear that they are interchangeable and there was a report here this week of someone moving between Drupal and WP with no problems. I don't know if such a move is officially supported, but it seems to work fine. :)
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: Database portability
January 13, 2012, 02:43:52 am
Thanks Hershel - that's good to know.  :)
Graham Mitchell
http://mc3.coop
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • Database portability

This forum was archived on 2017-11-26.