{"repo":"tomroh/bcputility","free":true,"listed":false,"github":"https://github.com/tomroh/bcputility","clone":"git clone https://github.com/tomroh/bcputility.git","description":"R package for fast bulk imports/exports from/to SQL Server with the bcp command line utility","language":"R","stars":18,"topics":["database","sql","r","spatial","sqlserver"],"license":null,"category":"databases-storage","readme_excerpt":"bcputility bcputility is a wrapper for the command line utility program from SQL Server that does bulk imports/exports. The package assumes that bcp is already installed and is on the system search path. For large inserts to SQL Server over an ODBC connection (e.g. with the \"DBI\" package), writes can take a very long time as each row generates an individual insert statement. The bcp Utility greatly improves performance of large writes by using bulk inserts. An export function is provided for convenience, but likely will not significantly improve performance over other methods. Prerequisites The system dependencies can be downloaded and installed from Microsoft. It is recommended to add bcp and sqlcmd to the system path. Installation You can install the released version of bcputility from CRAN with: Install the development version with: To check if the prerequisite binaries are on the path: If bcp and sqlcmd is not on the system path or you want to override the default, set the option with the full file path: Usage Trusted Connection (default): SQL Authentication: Benchmarks Benchmarks were performed with a local installation of SQL Server Express. When testing with a remote SQL Server, performance of bcp over odbc was further improved. Import expr min lq mean median uq max neval :--------------- ---------: ---------: ---------: ---------: ---------: --------: -----: bcpImport1000 15.017385 16.610868 17.405555 17.656265 18.100990 19.44482 30 bcpImport10000 10.091266 10.657926 ","default_branch":null,"files":null,"tree":[],"storefront":"/r/tomroh","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/tomroh/bcputility/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}