schemazen
schemazen copied to clipboard
Problems with SEED_VALUE and INCREMENT_VALUE data type
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.
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