CiviCRM Community Forums (archive)

Hi,

We've just been tasked with trying to migrate from a very old install of Civi on Drupal to the latest version on Wordpress.
I'm in the process of trying to figure out how the database will port across, and have started coming across a few changes to the table structure.

For example, civicrm_activity in the Drupal DB has a column 'source_contact_id', which no longer exists in 4.4.4. I've found some hints as to what happened to that particular column, but am still not sure exactly what to do with it.

I've tried searching around for info about what happened over the course of the (many) upgrades to the DB, but can't find any definitive guide (and the upgrade scripts in the Wordpress plugin don't seem to go back that far).

Can anyone point me at somewhere that might outline what changes were made in the interim versions?

Thanks for the response...

Writing PHP and such is not a problem, as we are a team of developers, but we just need to know how the data needs to be restructured... Our first idea was exactly the same - to upgrade Drupal and CiviCRM, then export, but unfortunately, the Drupal installation has been heavily modified by an external third party (who is no longer involved) which makes us a bit wary.

Still, we'll try it on a dev installation and see how it goes. I think we might still need to try converting it manually.