I recall hearing that Connect could be installed on Microsoft SQL instead of MYSQL. However I’m unable to find any documentation around that. Am I missing something? Or has that not been made available yet?
Thanks,
Nate
This is true - now, sort of. Lets better speak of “linked to MS SQL” or “use MS SQL” instead of “Installing”.
You need a running and prepared MS SQL server. With Connect 1.5 you can set your DB connection to use that MS SQL server instead of MySQL via the Server Configuration Tool after you have installed Connect. And starting with Connect 1.6 you can use the installer dialog to connect to MS SQL.
However, MS SQL wil NOT be included in the setup, it has to be set up and maintained separately and by the user / customer himself.
Documentation will be updated soon.
Ok, so as of right now (version 1.5) Connect needs to be installed with MYSQL and then after install can be migrated (aka linked to) Microsoft SQL. After that happens the MYSQL database could be turned off, correct?
Then at some point in the future, when 1.6 is released, the Connect installer will allow Microsoft SQL to be used from the very beginning (but the installer DOES NOT install the Microsoft SQL instance).
Ok, so as of right now (version 1.5) Connect needs to be installed with MYSQL and then after install can be migrated (aka linked to) Microsoft SQL. After that happens the MYSQL database could be turned off, correct?
If you install the local MySQL, then the installer creates a dependency between OL Connect Server and this MySQL service. I.e. if you want to stop MySQL after switching over to MS SQL, you first have to remove the dependency between the two services:
Open a commandline window with full admin rights and enter
sc config OLConnect_Server depend= /
This removes the dependency.
Please be aware: the key word “depend” must be followed immediately by the equals sign, but between the equals sign and the forward slash there must be a space!