[support] How to use two dbms for drupal

[Jamie Holly]

Due to the design of the database layer in Drupal 6 (and less) you can't 
mix different database engines (that feature is coming in D7).

My suggestion would be to dump the PostgreSQL DB and import it into a 
MySQL DB, then do the import.  The other thing you could do is create 
your own PostgreSQL connector to use for the import, totally bypassing 
the Drupal database layer on that database.

Jamie Holly
http://www.intoxination.net
http://www.hollyit.net


On 1/25/2010 8:59 AM, Michel Morelli wrote:
> Hi all. I need to import an old site (based on a proprietary CMS based 
> on postgres) on drupal 6.x based on mysql.
>
> I have thinked that two $db_url['XXX'] were enough, 1 (default) for 
> mysql and the other (oldweb) for postgres.
>
> But I receive this error when I try to use the connection to postgresql:
>
> *Fatal error*: Cannot redeclare db_status_report() (previously 
> declared in.......
>
> How can I connect to an postgres db if my site run on mysql?
>
> M.
> -- 
> Michel 'ZioBudda' Morellimichel at ziobuddalabs.net
> Sviluppo applicazioni CMS DRUPAL e web dinamiche (LAMP+Ajax)
> Telefono: 0200619074
> Telefono Cell: +39-3939890025 --  Fax: +39-0291390660
>
> http://www.ziobudda.net                          ICQ: 58351764
> http://www.ziobuddalabs.it                       Skype: zio_budda
> http://www.ziodrupal.net        			MSN:michel at ziobuddalabs.it
> 						JABBER:michel at ziobuddalabs.it
>    
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20100125/5e4d9285/attachment.html