Package: bcputility 0.4.6


Thomas Roh
bcputility: Wrapper for SQL Server bcp Utility
Provides functions to utilize a command line utility that does bulk inserts and exports from SQL Server databases.
Authors:
bcputility_0.4.6.tar.gz
bcputility_0.4.6.zip(r-4.7)bcputility_0.4.6.zip(r-4.6)bcputility_0.4.6.zip(r-4.5)
bcputility_0.4.6.tgz(r-4.6-any)bcputility_0.4.6.tgz(r-4.5-any)
bcputility_0.4.6.tar.gz(r-4.7-any)bcputility_0.4.6.tar.gz(r-4.6-any)
bcputility_0.4.6.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
card.svg |card.png
bcputility/json (API)
NEWS
| # Install 'bcputility' in R: |
| install.packages('bcputility', repos = c('https://tomroh.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/tomroh/bcputility/issues
Pkgdown/docs site:https://bcputility.delveds.com
Last updated from:bf58d10b91. Checks:9 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | OK | 110 | ||
| source / vignettes | OK | 145 | ||
| linux-release-x86_64 | OK | 109 | ||
| macos-release-arm64 | OK | 91 | ||
| macos-oldrel-arm64 | OK | 74 | ||
| windows-devel | OK | 88 | ||
| windows-release | OK | 264 | ||
| windows-oldrel | OK | 71 | ||
| wasm-release | OK | 97 |
Exports:bcpExportbcpImportbcpVersioncheckTableExistscreateTabledropTableintmakeConnectArgsmapDataTypessqlcmdVersionvarBinaryvarChar
Dependencies:classclassIntdata.tableDBIe1071KernSmoothMASSproxyRcpps2sfunitswk
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Export data from SQL Server | bcpExport |
| Import data to SQL Server | bcpImport |
| Create or drop table | checkTableExists createTable dropTable |
| Create a named list of connection arguments to translate to bcp and sqlcmd options | makeConnectArgs |
| Determine SQL Server data types from data frame. Follows SQL Server data type size constraints and chooses the smallest data type size. | int mapDataTypes varBinary varChar |
| Check bcp and sqlcmd versions | bcpVersion sqlcmdVersion SQLServerCLIVersions |