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

[Rusty Newton (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-27255?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rusty Newton updated ASTERISK-27255:
------------------------------------

    Status: Open  (was: Triage)

> 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 as mentioned here: http://bit.ly/2x9r8pb.
> 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)