[asterisk-bugs] [JIRA] (ASTERISK-27255) alembic: Add support for Microsoft SQL server

[Florian Floimair (JIRA)]

Florian Floimair created ASTERISK-27255:
-------------------------------------------

             Summary: alembic: Add support for Microsoft SQL server
                 Key: ASTERISK-27255
                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-27255
             Project: Asterisk
          Issue Type: Improvement
      Security Level: None
          Components: Contrib/General
    Affects Versions: 14.6.0
            Reporter: Florian Floimair
            Severity: Minor


The alembic scripts included with Asterisk are currently not working with MS-SQL.

This is mainly due to the fact, that MS-SQL has no native Enum-type and therefore needs to work with constraints.

The referenced gerrit change request enhances the alembic environment and the migration scripts so that they work with MS-SQL as well.

Successfully tested migrations with alembic 0.8.8, sqlalchemy 1.0.15 and MS-SQL server 13.1 (on Microsoft Azure) both online and offline (with the --sql switch) as well as checked for any regressions by also using MySQL 5.7.



--
This message was sent by Atlassian JIRA
(v6.2#6252)