sqlserver21012不支持，默认sqlserver版本为2016

[sunshinegone]

[drebrez]

Hi @sunshinegone,

thanks for reporting the issue, but I need some additional info.

which MicrosoftSQL server version do you use?

could you try to run these query manually to see if they work or maybe your server doesn't have some column?

SELECT t.name as Name,
       s.name as 'Schema',
       CASE WHEN p.period_type IS NULL THEN 0 ELSE 1 END AS 'HasPeriod',
       p.name AS 'PeriodName',
       (SELECT c.name FROM sys.columns c WHERE c.object_id = t.object_id AND c.column_id = p.start_column_id) AS 'PeriodStartColumn',
       (SELECT c.name FROM sys.columns c WHERE c.object_id = t.object_id AND c.column_id = p.end_column_id) AS 'PeriodEndColumn',
       CASE t.temporal_type WHEN 2 THEN 1 ELSE 0 END as 'HasHistoryTable',
       OBJECT_SCHEMA_NAME(t.history_table_id) AS 'HistoryTableSchema',
       OBJECT_NAME(t.history_table_id) AS 'HistoryTableName',
       o.modify_date as 'ModifyDate'
FROM sys.tables t
JOIN sys.schemas s ON s.schema_id = t.schema_id
JOIN sys.objects o ON o.object_id = t.object_id
LEFT JOIN sys.periods p ON p.object_id = t.object_id
WHERE o.type = 'U' AND s.name <> 'sys' AND t.temporal_type <> 1

and

SELECT isc.TABLE_SCHEMA as 'Schema',
       isc.TABLE_NAME as 'TableName',
       isc.COLUMN_NAME as 'Name',
       CAST(isc.ORDINAL_POSITION AS bigint) as 'OrdinalPosition',
       isc.COLUMN_DEFAULT as 'ColumnDefault',
       dc.name as 'DefaultConstraintName',
       CASE UPPER(isc.IS_NULLABLE) WHEN 'NO' THEN 0 ELSE 1 END as 'IsNullable',
       isc.DATA_TYPE as 'DataType',
       isc.CHARACTER_MAXIMUM_LENGTH as 'CharacterMaxLength',
       isc.NUMERIC_PRECISION as 'NumericPrecision',
       isc.NUMERIC_SCALE as 'NumericScale',
       isc.DATETIME_PRECISION as 'DateTimePrecision',
       isc.CHARACTER_SET_NAME as 'CharacterSetName',
       isc.COLLATION_NAME as 'CollationName',
       IsNull(ic.is_identity, 0) as 'IsIdentity',
       IsNull(ic.seed_value, 0) as 'IdentitySeed',
       IsNull(ic.increment_value, 0) as 'IdentityIncrement',
       IsNull(cc.is_computed, 0) as 'IsComputed',
       IsNull(c.is_rowguidcol, 0) as 'IsRowGuidCol',
       cc.definition as 'Definition',
       isc.DOMAIN_SCHEMA as 'UserDefinedDataTypeSchema',
       isc.DOMAIN_NAME as 'UserDefinedDataType',
       c.generated_always_type as 'GeneratedAlwaysType',
       c.is_hidden as 'IsHidden'
FROM INFORMATION_SCHEMA.COLUMNS isc
JOIN sys.columns c ON object_id(QUOTENAME(isc.TABLE_SCHEMA) + '.' + QUOTENAME(isc.TABLE_NAME)) = c.object_id AND isc.COLUMN_NAME = c.name
LEFT JOIN sys.identity_columns ic ON c.object_id = ic.object_id AND c.column_id = ic.column_id
LEFT JOIN sys.computed_columns cc ON c.object_id = cc.object_id AND c.column_id = cc.column_id
LEFT JOIN sys.default_constraints dc ON c.object_id = dc.parent_object_id AND c.column_id = dc.parent_column_id
WHERE isc.TABLE_SCHEMA <> 'sys'

Knowing the exact server version and which columns are not present would allow to had a fix in the code.

Best regards

[sunshinegone]

i used the version was sqlserver 2012r2

…

---- 回复的原邮件 ---- | 发件人 | Daniele ***@***.***> | | 日期 | 2026年03月11日 21:52 | | 收件人 | ***@***.***> | | 抄送至 | ***@***.***>***@***.***> | | 主题 | Re: [TiCodeX/SQLSchemaCompare] sqlserver21012不支持，默认sqlserver版本为2016 (Issue #96) | drebrez left a comment (TiCodeX/SQLSchemaCompare#96) Hi @sunshinegone, thanks for reporting the issue, but I need some additional info. which MicrosoftSQL server version do you use? could you try to run these query manually to see if they work or maybe your server doesn't have some column? SELECT t.name as Name, s.name as 'Schema', CASE WHEN p.period_type IS NULL THEN 0 ELSE 1 END AS 'HasPeriod', p.name AS 'PeriodName', (SELECT c.name FROM sys.columns c WHERE c.object_id = t.object_id AND c.column_id = p.start_column_id) AS 'PeriodStartColumn', (SELECT c.name FROM sys.columns c WHERE c.object_id = t.object_id AND c.column_id = p.end_column_id) AS 'PeriodEndColumn', CASE t.temporal_type WHEN 2 THEN 1 ELSE 0 END as 'HasHistoryTable', OBJECT_SCHEMA_NAME(t.history_table_id) AS 'HistoryTableSchema', OBJECT_NAME(t.history_table_id) AS 'HistoryTableName', o.modify_date as 'ModifyDate' FROM sys.tables t JOIN sys.schemas s ON s.schema_id = t.schema_id JOIN sys.objects o ON o.object_id = t.object_id LEFT JOIN sys.periods p ON p.object_id = t.object_id WHERE o.type = 'U' AND s.name <> 'sys' AND t.temporal_type <> 1 and SELECT isc.TABLE_SCHEMA as 'Schema', isc.TABLE_NAME as 'TableName', isc.COLUMN_NAME as 'Name', CAST(isc.ORDINAL_POSITION AS bigint) as 'OrdinalPosition', isc.COLUMN_DEFAULT as 'ColumnDefault', dc.name as 'DefaultConstraintName', CASE UPPER(isc.IS_NULLABLE) WHEN 'NO' THEN 0 ELSE 1 END as 'IsNullable', isc.DATA_TYPE as 'DataType', isc.CHARACTER_MAXIMUM_LENGTH as 'CharacterMaxLength', isc.NUMERIC_PRECISION as 'NumericPrecision', isc.NUMERIC_SCALE as 'NumericScale', isc.DATETIME_PRECISION as 'DateTimePrecision', isc.CHARACTER_SET_NAME as 'CharacterSetName', isc.COLLATION_NAME as 'CollationName', IsNull(ic.is_identity, 0) as 'IsIdentity', IsNull(ic.seed_value, 0) as 'IdentitySeed', IsNull(ic.increment_value, 0) as 'IdentityIncrement', IsNull(cc.is_computed, 0) as 'IsComputed', IsNull(c.is_rowguidcol, 0) as 'IsRowGuidCol', cc.definition as 'Definition', isc.DOMAIN_SCHEMA as 'UserDefinedDataTypeSchema', isc.DOMAIN_NAME as 'UserDefinedDataType', c.generated_always_type as 'GeneratedAlwaysType', c.is_hidden as 'IsHidden' FROM INFORMATION_SCHEMA.COLUMNS isc JOIN sys.columns c ON object_id(QUOTENAME(isc.TABLE_SCHEMA) + '.' + QUOTENAME(isc.TABLE_NAME)) = c.object_id AND isc.COLUMN_NAME = c.name LEFT JOIN sys.identity_columns ic ON c.object_id = ic.object_id AND c.column_id = ic.column_id LEFT JOIN sys.computed_columns cc ON c.object_id = cc.object_id AND c.column_id = cc.column_id LEFT JOIN sys.default_constraints dc ON c.object_id = dc.parent_object_id AND c.column_id = dc.parent_column_id WHERE isc.TABLE_SCHEMA <> 'sys' Knowing the exact server version and which columns are not present would allow to had a fix in the code. Best regards — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.Message ID: ***@***.***>

[drebrez]

Hi @sunshinegone,

sql server 2012 is very old and not even supported anymore by microsoft.

By looking at the screenshot I can see that there are various system tables/columns that were not present until sql server 2016 which I never really tested since there's no official docker image for it.

I'm not planning to add support for such outdated versions, so I suggest to download the source code of the application and do the changes yourself to make it work.
You would have to do some changes to the various queries in this file: https://github.com/TiCodeX/SQLSchemaCompare/blob/master/SQLSchemaCompare.Infrastructure/DatabaseProviders/MicrosoftSqlDatabaseProvider.cs