Databases Sugar Community Edition and Sugar Professional Edition support the MySQL and Microsoft SQL Server databases. In addition to these two databases, Sugar Enterprise Edition supports the Oracle database. In general, Sugar uses only common database functionality, and application logic is embedded in the PHP code. This means that Sugar uses no database triggers or stored procedures. This design approach simplifies coding and testing across different database vendors. Therefore the only implementation difference that you will typically find across the various supported databases is column types. Sugar uses the mysql PHP extension for MySQL support (or mysqli if it enabled), the mssql extension for Microsoft SQL Server support, and the oci8 extension for Oracle support. Sugar does not support generic ODBC access or other database drivers such as PDO.
Copyright 2004-2008 SugarCRM Inc. Product License