[Phpgroupware-developers] Synchronizations across different databasesystems

[sigurdne]

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