add official MSSQL support

[DavidBadura]

Q	A
Bug report?	no
Feature request?	yes
BC Break report?	no
RFC?	no

We can not currently provide any official support for MSSQL, as we can not test it. With AppVeyor we have the possibility.

Doctrine is attending to integrate AppVeyor (doctrine/dbal#2617). We should just wait until they are done and then we'll take it 😄

[photodude]

We did this with Joomla already
joomla/joomla-cms#13790
and the Joomla-Framework Database package
joomla-framework/database#72

The Doctrine DBAL implementation is just different
Note: lots of packages are doing this now

[photodude]

Also there are the MSSQL Linux package now so there is a way to do this on Travis CI

The SQL Server for Linux preview is available as a docker image. Assuming we can setup Travis to protect our access key to the private preview, we could use docker on Travis CI builds to execute against tests SQL Server.

https://www.microsoft.com/en-us/server-cloud/sql-server-on-linux.aspx

https://docs.travis-ci.com/user/docker/

[photodude]

Apparently, someone has a workaround for testing Oracle DB on travis ci as well https://github.com/cbandy/travis-oracle

an Oracle account is required and the Oracle username and password has to be in the build environment variables either as hidden repository settings or encrypted variables

[DavidBadura]

Amazing! Thanks for the valuable information! I'll try it soon :-)

[photodude]

you are welcome

[photodude]

FYI Doctrine is working on implementing Oracle testing on the DBAL package using @continuousphp

https://continuousphp.com

Setup is all done in the account via their web interface. so you are on your own with that.

[github-actions]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.