search

keboola / db-extractor-mssql

MIT License
1 stars 2 forks source link

allow timestamp datatype for incremental fetching #112

Closed kacurez closed 5 years ago

kacurez commented 5 years ago

timestamp is a synonym for rowversion data type that is an incrementing number for the table updates, hence could be used for incremental fetching. https://docs.microsoft.com/en-us/sql/t-sql/data-types/rowversion-transact-sql?view=sql-server-2017

https://github.com/keboola/db-extractor-mssql/blob/master/src/Keboola/DbExtractor/Extractor/MssqlDataType.php#L16

https://keboola.slack.com/archives/C035LGNK5/p1554991064006400

pivnicek commented 5 years ago

Just one caution for this, the timestamp type is binary so will need to be converted somehow.

Halama commented 5 years ago

Zendesk https://keboola.zendesk.com/agent/tickets/10244

Do we want to implement this?

kacurez commented 5 years ago

dalsi klient narazil na incremental fetching via timestamp v mssql https://keboola.zendesk.com/agent/tickets/10467