SQL Server Compatibility

Known features not yet supported

This functionality is not yet supported in comparison, export and sync. You should take care of it yourself. High severity issues usually require manual editing of the sync script, while lower severity issues can often be handled in preparatory or final scripts.

Code Supported Severity Caption Description
14Objects WITH ENCRYPTIONWhen an object is created WITH the ENCRYPTION option, the original object statement cannot be obtained from any catalog views (sys.sql_modules). In this case, AutosyncDB uses a throw stub as a legitimate object statement instead of the original one, which allows it to continue working with such databases. However, you should then take care of comparing, creating and re-creating such objects yourself.
CREATE FUNCTION fn_secret() RETURNS int WITH ENCRYPTION AS
BEGIN ...
GO
CREATE PROCEDURE sp_secret WITH ENCRYPTION AS
BEGIN ...
25Table columns MASKED WITH FUNCTION (Dynamic Data Masking)
CREATE TABLE users
(
    email nvarchar(255) MASKED WITH (FUNCTION = 'email()'),
    phone varchar(10) MASKED WITH (FUNCTION = 'partial(3,"XXXXXXXXXX",2)')
    ...
33SEQUENCE objects
CREATE SEQUENCE RadCircle
    AS decimal (3,0)
    START WITH 0
    INCREMENT BY 15
    MINVALUE 0
    MAXVALUE 360
    CYCLE
    CACHE 12
42PLAN GUIDES
EXEC sp_create_plan_guide
    @name = N'events_top1',
    @stmt = N'SELECT TOP 1 * FROM events ORDER BY dateins DESC',
    @type = N'SQL',
    @module_or_batch = NULL,
    @params = NULL,
    @hints = N'OPTION (MAXDOP 1)';
53SYNONYM objects
65SQL Graph Architecture objects
73Service Broker Architecture objects
83Extended Stored Procedures
92User STATISTICS objects
105Security Policy objects
115System-Versioned Temporal tables
125Table columns ENCRYPTED WITH (Always Encrypted Tech)
135Tables as FileTables
145Table LOB storage space location (TEXTIMAGE_ON)
155Tables as FILESTREAM data storage (FILESTREAM_ON)
164LOCK_ESCALATION table option
175Full-Text Search
183Database DDL triggers
195SPATIAL indexes
201Default and Rule objects
214Default and Rule objects (in use)
Not sure yet?

If you have some doubts about specific features, you can run some tests by comparing a database with such features to itself and then to a clean database. The answers to these questions will help you make a decision: Does AutosyncDB show these features correctly in the Differences view? Is the comparison correct? Is the sync script correct?