storebrand / target-mssql

Singer.io compatible Target for SQL Server. Created with the Meltano SDK.
Apache License 2.0
3 stars 17 forks source link

Not create identity columns #3

Closed radbrt closed 1 year ago

radbrt commented 1 year ago

Turns out identity columns have more to do with auto increment, and sqlalchemy for some reason creates autoincrement by default on numeric index columns. So basically, the troubles with identity columns can be fixed by adding the autoincrement=False option when defining key columns.

Also added two tests, because tests are good.