Migrating from MySql to Mssql

SuiteCRM Forum - English Language Installation & Upgrade Help
1

What settings do I change in the config.php to make this work?
I have made this change, is there something else?
Old

    'db_host_name' => 'iaigfk4',
    'db_user_name' => 'user',
    'db_password' => 'password',
    'db_name' => 'sugarcrm',
    'db_type' => 'mysql',

New

    'db_host_name' => 'gfksql',
    'db_host_instance' => 'gfksql',
    'db_user_name' => 'User',
    'db_password' => 'Password',
    'db_name' => 'sugarcrm',
    'db_type' => 'mssql',
    'db_port' => '1433',

I have converted the DB, but cant seem to get it to hookup.

Thanks

2

Hi,

We had the same problem and you need to use something like this to make SuiteCRM connect to MSSQL DB:


'dbconfig' => 
  array (
    'db_host_name' => 'tcp:{ip or name of host},{port}',
    'db_host_instance' => '{instance_name}',
    'db_user_name' => 'username',
    'db_password' => 'password',
    'db_name' => 'database name',
    'db_type' => 'mssql',
    'db_port' => '',
    'db_manager' => 'SqlsrvManager',
  ),

Hope it helps.