Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problems with SEED_VALUE and INCREMENT_VALUE data type #149

Open
ratollama opened this issue Nov 28, 2017 · 1 comment
Open

Problems with SEED_VALUE and INCREMENT_VALUE data type #149

ratollama opened this issue Nov 28, 2017 · 1 comment

Comments

@ratollama
Copy link

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.

@kenlassesen
Copy link

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants