Finally, its done!!!

Included are two scripts in a ZIP file. The basis of the scripts got me from D4.7 to D6. I've been running D6 now for a few days and I'm satisfied there aren't any major errors. The scripts are modified however, since I have different table prefix needs than what the standard issue Oracle driver supports. Therefore I haven't actually run either script above, but I'm confident they'll work.

The pre-upgrade script prepares your data so it looks like a 5.x database with the separate CLOB table.

The post-upgrade script cleans up anything not done by the Drupal 6.x database upgrade system (update.php). This includes stuff not hit because it was hidden behind mysql/pgsql case statements.

Note I haven't run either script as-is because I have database table name prefixes that aren't compatible with this script. I went through the scripts and removed all the prefix handling, but it still might not work. If you find stuff that breaks please post here and I'll take a look at it.

Tips:

  • This script only really deals with the core-required tables and related objects, and some core-optional modules.
  • You will probably want to disable and uninstall (remove database tables) any non-core and non-required modules you use. If you need to keep module data or settings, export those to another table or some non-oracle storage format before you upgrade. After you upgrade, you can re-enable the modules, and the database tables will be created properly by the D6 Oracle driver.
CommentFileSizeAuthor
D4.7 update.zip13.24 KBsiromega
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

aaaristo’s picture

Status: Closed (fixed) » Needs review

Thanks siromega! It would be nice if someone would like to test those scripts, and report on this thread.

aaaristo’s picture

Assigned: siromega » Unassigned
cashwilliams’s picture

I'm going to test these scripts on a copy of an existing 4.7 site we have running. We're planning to move it to D6 very soon.

siromega’s picture

Thanks! Be sure to back up your data first and let us know how it turns out.

bohart’s picture

Version: 6.x-1.0-beta1 » 7.x-1.x-dev
Status: Needs review » Closed (won't fix)
Issue tags: +LutskGCW20

Drupal 6 is no longer supported.