schemazen icon indicating copy to clipboard operation
schemazen copied to clipboard

Problems with SEED_VALUE and INCREMENT_VALUE data type

Open ratollama opened this issue 7 years ago • 1 comments

I'm not quite sure if the problem is caused because I'm currently running Schema Zen or Sql Server in linux, but when I try to import data it fails because the field SEED_VALUE and INCREMENT_VALUE, defined in the query of LoadColumnIdentities method, are of type sql_variant. Casting - in the query - those two columns to nvarchar seems to solve the problem.

ratollama avatar Nov 28 '17 10:11 ratollama

I am submitted a pull request and made the following change to the source-- using your information for guidance

select s.name as TABLE_SCHEMA, t.name as TABLE_NAME, c.name AS COLUMN_NAME, cast(i.SEED_VALUE as varchar) AS SEED_VALUE, cast(i.INCREMENT_VALUE as varchar) AS INCREMENT_VALUE from sys.tables t

kenlassesen avatar Jun 14 '19 21:06 kenlassesen