Reference

All functions

bcpExport()

Export data from SQL Server

bcpImport()

Import data to SQL Server

bcpVersion() sqlcmdVersion()

Check bcp and sqlcmd versions

createTable() dropTable() checkTableExists()

Create or drop table

makeConnectArgs()

Create a named list of connection arguments to translate to bcp and sqlcmd options

mapDataTypes() varChar() varBinary() int()

Determine SQL Server data types from data frame. Follows SQL Server data type size constraints and chooses the smallest data type size.