[
https://issues.apache.org/jira/browse/NIFI-3585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15905577#comment-15905577
]
ASF GitHub Bot commented on NIFI-3585:
--------------------------------------
Github user mattyb149 commented on the issue:
https://github.com/apache/nifi/pull/1584
@patricker do you mind taking a look at this? I am no MS SQL expert by any
means, but I tested GenerateTableFetch and QueryDatabaseTable and they seem ok
to me.
> DB Adapter for MS SQL 2008
> --------------------------
>
> Key: NIFI-3585
> URL: https://issues.apache.org/jira/browse/NIFI-3585
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Core Framework
> Affects Versions: 1.2.0
> Reporter: Matt Burgess
> Assignee: Matt Burgess
> Priority: Minor
> Fix For: 1.2.0
>
>
> NIFI-3481 introduced a DatabaseAdapter implementation for Microsoft SQL
> Server 2012+, it is not compatible with MS SQL 2008 because of its use of
> OFFSET and FETCH, e.g.
> This case is to introduce support for earlier versions of SQL Server to the
> database fetching processors such as QueryDatabaseTable and
> GenerateTableFetch. It may be the case that the generated SQL is awkward and
> less-than-ideal (more like Oracle's pagination query), but this will enable
> those processors to interact with SQL Server versions prior to 2012.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
