Right now, there is no DBTNG Oracle driver suitable for use with the Migrate module (there is a contrib Oracle driver, but it currently only works for using Oracle as your Drupal database, not as an external database). This means Oracle needs its own source plugin similar to the existing mssql.inc for Microsoft SQL Server.

Work has begun on this plugin - as a first pass, I should be committing basic support (no blobs) soon.

Comments

mikeryan’s picture

mikeryan
he/him
Primary language English
Location Pittsfield, MA, USA
commented
Status: Active » Fixed

Done for D6 and D7, including an example module. There's also a simpletest, but it's currently disabled due to #362373: refreshVariables() loses variables from settings.php.

To use the Oracle source, you will need to enable the oci8 extension in PHP, and define the connection info for your Oracle database in settings.php:

$conf['oracle_db'] = array(
  'username' => 'Oracle_username',
  'password' => 'Oracle_password',
  'connection_string' => '//Oracle_host/SID',
);

See http://us3.php.net/manual/en/function.oci-connect.php for more information on forming the connection_string.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.