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

[Kevin Harwell (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-27255?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=238611#comment-238611 ] 

Kevin Harwell commented on ASTERISK-27255:
------------------------------------------

There was some concern about this going into the code base, and what that means moving forward from a maintenance perspective. After some discussion it was decided that modifying the Asterisk alembic scripts in order to allow MS-SQL Server support would be acceptable. However, with the following caveat:
{panel}
MS-SQL Server support in Asterisk is not officially supported and should be treated as-is. Future changes/additions to any alembic scripts may break things for MS-SQL Server.
{panel}
That being said, as changes are made to the alembic scripts effort should and will be made to try and not break things, but it's just not guaranteed. Also, patches of course will be accepted from anyone with an interest in keeping the MS-SQL support current.

> 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)