sql-migrate icon indicating copy to clipboard operation
sql-migrate copied to clipboard

Set Id column with max size 4000 where dialect is mssql (sqlserver)

Open jvictor27 opened this issue 1 year ago • 0 comments

Problem: Using the mssql dialect, when the change control table is going to be created, the column information of the PK id column is nvarchar(max), but the sqlserver does not allow this type of field as index. Returning error "Could not create constraint or index. See previous errors."

Solution: Including the mssql dialect in the already existing condition of validation of the Id column in for other dialects, the Id column will now have a defined size of 4000 and so when gorp translates to the language of the database, the id field will be nvarchar(4000) , avoiding the current error "Could not create constraint or index. See previous errors."

jvictor27 avatar Jan 16 '23 19:01 jvictor27