Is SQL Server planned in the future? about acra HOT 1 CLOSED

AcraServer works as proxy for PostgreSQL wire protocol and MySQL wire protocol because these are open protocols and these database are SQL compliant. Overall, Acra supports all databases that works over these protocols.

But not all SQL databases are SQL compliant. See the SQL Compliance table.

AFAIK, Microsoft SQL Server uses its own proprietary SQL protocol and is not fully SQL compliant.

AFAIK, Azure SQL used MySQL protocol under the hood, but they did a lot of changes to it. Azure SQL is not fully compliant with SQL protocol either (see https://docs.microsoft.com/en-us/azure/azure-sql/database/transact-sql-tsql-differences-sql-server) — the syntax and commands are different.

TLDR: these databases use different SQL flavours, mostly proprietary. Even if we teach AcraServer to support Microsoft SQL Server and Azure SQL Server, we couldn't guarantee the stability and maintainability of Acra because these SQL servers might change their behaviour in next version. That's definitely not something we plan to do in the nearest future for Acra Community Edition (custom flavors for Acra Enterprise Edition might be a case).

To work with Microsoft SQL Server and Azure SQL Server we recommend using AcraTranslator (encryption-as-an-API) instead of AcraServer (SQL proxy). Application can store data in any database, just call AcraTranslator to encrypt/decrypt the data before/after storing. Please follow the AcraTranslator description and the guide.

from acra.