Package: bcputility 0.4.4
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.4.tar.gz
bcputility_0.4.4.zip(r-4.5)bcputility_0.4.4.zip(r-4.4)bcputility_0.4.4.zip(r-4.3)
bcputility_0.4.4.tgz(r-4.4-any)bcputility_0.4.4.tgz(r-4.3-any)
bcputility_0.4.4.tar.gz(r-4.5-noble)bcputility_0.4.4.tar.gz(r-4.4-noble)
bcputility_0.4.4.tgz(r-4.4-emscripten)bcputility_0.4.4.tgz(r-4.3-emscripten)
bcputility.pdf |bcputility.html✨
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
Last updated 2 months agofrom:5b2ff98798. Checks:OK: 7. Indexed: yes.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Aug 31 2024 |
| R-4.5-win | OK | Aug 31 2024 |
| R-4.5-linux | OK | Aug 31 2024 |
| R-4.4-win | OK | Aug 31 2024 |
| R-4.4-mac | OK | Aug 31 2024 |
| R-4.3-win | OK | Aug 31 2024 |
| R-4.3-mac | OK | Aug 31 2024 |
Exports:bcpExportbcpImportbcpVersioncheckTableExistscreateTabledropTableintmakeConnectArgsmapDataTypessqlcmdVersionvarBinaryvarChar
Dependencies:classclassIntdata.tableDBIe1071KernSmoothmagrittrMASSproxyRcpps2sfunitswk
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 |