MySQL(website) and MSSQL(evedump) on other IP address

[DutchRebelNL]

Is it possible to use MySQL for the website itself and MSSQL2012 for the evedump file?

I have the MySQL with my hosting and have a own MSSQL2012 server. The problem is I don't get how to connect to the MSSQL2012. I don't get error messages just a blank page.

The reason that I want to do this is because the eve dumps are to large to import to my MySQL server (max 50MiB).

How I get it out of the source file:

/*************************************************************************
    Database for OOE (users, API details, etc)
*************************************************************************/
$config['database']['dsn'] = 'mysql:host=localhost;dbname=outofeve';
$config['database']['user'] = 'admin';
$config['database']['pass'] = 'pass';

/*************************************************************************
    Database generated from Eve database dump
*************************************************************************/
$config['evedatabase']['dsn'] = 'mysql:host=localhost;dbname=evedump';
$config['evedatabase']['user'] = 'admin';
$config['evedatabase']['pass'] = 'pass';

What I was thinking to change:

/*************************************************************************
    Database generated from Eve database dump
*************************************************************************/
$config['evedatabase']['dsn'] = 'mssql:host=IP address;dbname=evedump';
$config['evedatabase']['user'] = 'admin';
$config['evedatabase']['pass'] = 'pass';

My MSSQL2012 had a working connection to the net.

I hope you guys can help me with this.

[shrimpza]

Hi

Unfortunately, I'm not quite sure what is and isn't possible regarding accessing the dump via MS SQL.

Assuming all the same tables exist (including things like eveIcons) in the MSSQL DB, OOE does not make use of any special MySQL functionality that I'm aware of, so you might get lucky and it'll work.

You MAY need to install additional MS SQL drivers installed/built on your web server, see here: http://au2.php.net/manual/en/ref.pdo-dblib.php (linux web host) and here: http://au2.php.net/manual/en/ref.pdo-sqlsrv.php (windows web host).

Also see the DSN documentation on the above pages, since they seem to require either "dblib:host..." or "sqlsrv:host..." formats, rather than "mssql:...".

As an alternative, it might be easier to install MySQL on the remote "dump" machine, and use the MySQL dump...

[shrimpza]

Closing. If someone wants to experiment with a configuration like this and report findings/raise issues, that'll be cool.