RSQLServer

An R package that provides a SQL Server R Database Interface (DBI), based on jTDS JDBC driver.

This package wraps the jTDS SQL Server driver and extends the RJDBC classes and DBI methods. It defines a SQLServerDriver, SQLServerConnection & SQLServerRsult S4 classes as extensions of the RJDBC equivalent classes. Most of the DBI methods will simply be calls to methods defined by RJDBC classes. However, the dbConnect and some of the dbGetInfo methods are specific to SQL Server. The jTDS drivers do extend to Sybase SQL Server, but currently, only Microsoft SQL Server is supported by this package.

Installation

This will be submitted to CRAN in due course. However, you can install and try this out in the meantime:

install.packages('devtools')
devtools::install_github('imanuelcostigan/RSQLServer')

Usage

This package uses the standard R DBI generics:

library(DBI)
conn <- dbConnect(RSQLServer::SQLServer(), 'DatabaseName')
dbListTables(conn)
dbListFields(conn, 'tablename')
res <- dbSendQuery(conn, 'SELECT TOP 10 * FROM tablename')
dbFetch(res)
dbClearResult(res)
dbDisconnect(res)