Database Comparer Issue Tracker: http://barry.exp-host.ru/tracker/ ------------------------------------------- 19.07.2021. v.8.0.0.2451.Release FB: Fix "Column unknown. FNC.RDB$OWNER_NAME" on extract Grants for FB <= 2.5. FB3+: Sub-Routines removed from compare. FB3+: GRANT... USAGE ON... implemented for compare databases. 24.06.2021. v.8.0.0.2411.Release - FB3: GRANT / REVOKE fix. 08.06.2021. v.8.0.0.2405.Release - FB3: GRANTs fix for FUNCTIONs. 30.05.2021. v.8.0.0.2401.Release - FB3: GRANT EXECUTE TO fix. 13.04.2021. v.8.0.0.2400.Release - "Copy Profile" interface command fix. - "FB 2.5: 0001662: WITH... SELECT... for MERGE statement. 06.04.2021. v.8.0.0.2392.Release - Compare Object Grants fix. - "Update Generator Values" (IB/FB) improved. 10.11.2020. v.8.0.0.2361.Release - Interface changes: Compare through Profiles. 10.11.2020. v.8.0.0.2359.Beta FB 2.1+: - WITH [RECURSIVE] ... SELECT in Expression fix. https://www.clevercomponents.com/tracker/view.php?id=1648 26.12.2019. v.8.0.0.1790.Beta MSSQLParser, MSSQLExec (VCL): - Load script from file fixes. 25.12.2019. v.8.0.0.1748.Beta TableDataComparer: - Unicode output file (Result.SQL) codepage fix. https://www.clevercomponents.com/tracker/view.php?id=570 MSSQL 2014+: - CHECK constraint in table-DDL. - Fix AV on parse script with finished GO at end without CrLf (short text). https://www.clevercomponents.com/tracker/view.php?id=1586 23.12.2019. v.8.0.0.1693.Beta FB 3+: - DATEADD(WEEK,...) http://barry.exp-host.ru/tracker/view.php?id=1533 - MERGE... WHEN [NOT] MATCHED [ AND ] THEN - EXECUTE STATEMENT - NATURAL - USING () - EXTRACT(MILLISECOND...) http://barry.exp-host.ru/tracker/view.php?id=1529 MSSQL 2014+, 2016+: - CREATE FULLTEXT CATALOG - CREATE FULLTEXT INDEX - FREETEXTTABLE, CONTAINSTABLE (...) in SELECT - SEMANTICKEYPHRASETABLE, SEMANTICSIMILARITYDETAILSTABLE, SEMANTICSIMILARITYTABLE - DataTypes: datetime2, smalldatetime, datetimeoffset http://barry.exp-host.ru/tracker/view.php?id=1525 - CREATE SEQUENCE ... - NEXT VALUE FOR [ OVER () ] http://barry.exp-host.ru/tracker/view.php?id=1583 - DATE, TIME datatype - AT TIME ZONE PostgreSQL 12.1: - Extract domain with check constraint. - Domain default. - CREATE EXTENSION - COMMENT ON EXTENSION - References: [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] - Constraints: [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ] - FOR n IN SELECT .... LOOP ... END LOOP - Select ... LIMIT... OFFSET... FETCH... - Declare local variables - WHILE statement - ELSIF & ELSEIF - Parse label: <