Add compatibility_level config

[slavad]

Issue

You can't specify compatibility_level in the db config

Expected behavior

You should be able to do this

Actual behavior

If I add compatibility_level: 130 in database.yml, it's ignored, the compatibility level is set to 140 (default for my db version)

How to reproduce

Add compatibility_level: 130 to the db config in database.yml

Details

• Rails version: n/a
• SQL Server adapter version: n/a
• TinyTDS version: n/a
• FreeTDS details: n/a

I forked the repo and added this feature. Is it ok if I create a pull request?

The feature branch was branched off the tag v7.2.1

[aidanharan]

@slavad Why would you change the compatibility level of a database when you connect to it? If it's a once off task then doing it manually would be better.

[slavad]

@aidanharan no, the compatibility level would be set during creation.

The compatibility_level setting would work like the collation setting (both in database.yml)

[slavad]

@aidanharan check this out #1254