[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-developers] Synchronizations across different databasesyst
From: |
sigurdne |
Subject: |
[Phpgroupware-developers] Synchronizations across different databasesystems |
Date: |
Tue, 7 Dec 2004 11:57:00 +0100 |
I am moving from mssql to pgsql (performance issue) - but then I need to
synchronize phpgroupware (pgsql) with an integrated system on mssql as a cron
job (I have a nice interface for this - using asyncservice)
I tried to initiate the db-objekt with :
$dbtype = $GLOBALS['phpgw_info']['server']['db_type'];
$dbtype_remote = 'mssql';
$GLOBALS['phpgw_info']['server']['db_type'] = $dbtype_remote;
$this->db_boei = CreateObject('phpgwapi.db');
$this->db_boei->Host = xx.xx.xx.xx;
$this->db_boei->Type = $dbtype_remote ;
$this->db_boei->Database = 'BOEI';
$this->db_boei->User = 'user';
$this->db_boei->Password = 'pw';
$this->db_boei->Halt_On_Error = 'yes';
$GLOBALS['phpgw_info']['server']['db_type'] = $dbtype;
But $GLOBALS['phpgw_info']['server']['db_type'] was not altered from pgsql
(the mssql db class wouldn't load)
My temporary workaround for this is to copy class.db_mssql.inc.php from
/phpgwapi/inc to /property/inc (and rename class db to class db_mssql) and
create the object as
$this->db_boei= CreateObject('property.db_mssql');
Any idea for dealing with this?
Sigurd
- [Phpgroupware-developers] Synchronizations across different databasesystems,
sigurdne <=