Enhanced Studio: MySQL or MS SQL ?

[kaisar]

Can you please tell me, what DB Sever uses Enhanced Studio ? MySQL or MS SQL Server ? How i understand from pdf documentation, MySQL (...For instance a variable-length string field having the Max Length equal to 255 can be created, on a MySQL DB Engine, through the following “DB Type” entry...). Im i right or not ?

[kenshiro]

Can you please tell me, what DB Sever uses Enhanced Studio ? MySQL or MS SQL Server ? How i understand from pdf documentation, MySQL (...For instance a variable-length string field having the Max Length equal to 255 can be created, on a MySQL DB Engine, through the following “DB Type” entry...). Im i right or not ?

Well, Enhanced Studio is not DB dependent, it supports all the SugarCRM DB Servers: MySQL, MSSQL and Oracle for SugarENT.

All the references to MySQL in the documentation are just examples. The string you enter in Studio as DB Type can be the creation string of any DB Server, and the DB-Type you choose in Module Builder is converted to the apprpriate type for each DB Engine as explained in the Admin's Manual at page 22.

Also, you can replace the MySQL php functions in the CODE fields with the corresponding MSSQL/Oracle ones.