Utilises The jTDS Project's JDBC 3.0 SQL Server driver to extend the RJDBC classes and DBI methods. It defines a SQLServerDriver, SQLServerConnection & SQLServerRsult S4 classes as extensions of the RJDBC equivalent classes with most DBI methods being thin extensions of the methods defined by RJDBC classes. However, the dbConnect interface is more convenient, and the data reading and writing capabilities found in RJDBC's fetch and dbWriteTable methods have been refined. The package also implements a SQL backend to the dplyr package.
| Version: | 0.2.0 |
| Depends: | R (≥ 3.2.0), DBI (≥ 0.3.1) |
| Imports: | methods (≥ 3.2.0), rJava (≥ 0.9.6), RJDBC (≥ 0.2-4), dplyr (≥ 0.4), assertthat (≥ 0.1), yaml (≥ 2.1.13), lubridate (≥ 1.3.3) |
| Suggests: | testthat |
| Published: | 2016-03-22 |
| Author: | Imanuel Costigan [aut, cre], The jTDS Project (for MSSQL Server driver) [aut], Simon Urbanek [ctb], Hadley Wickham [ctb], Romain Francois [ctb], RStudio [cph], The Legion Of The Bouncy Castle [cph, ctb] |
| Maintainer: | Imanuel Costigan <i.costigan at me.com> |
| BugReports: | https://github.com/imanuelcostigan/RSQLServer/issues |
| License: | GPL-2 |
| URL: | https://github.com/imanuelcostigan/RSQLServer |
| NeedsCompilation: | no |
| SystemRequirements: | Java (>= 1.3) |
| Materials: | README NEWS |
| CRAN checks: | RSQLServer results |
| Reference manual: | RSQLServer.pdf |
| Package source: | RSQLServer_0.2.0.tar.gz |
| Windows binaries: | r-devel: RSQLServer_0.2.0.zip, r-release: RSQLServer_0.2.0.zip, r-oldrel: RSQLServer_0.2.0.zip |
| OS X Mavericks binaries: | r-release: RSQLServer_0.2.0.tgz, r-oldrel: RSQLServer_0.1.1.tgz |
| Old sources: | RSQLServer archive |
Please use the canonical form https://CRAN.R-project.org/package=RSQLServer to link to this page.