Skip to contents

All functions

Export data from SQL Server
Import data to SQL Server
bcpVersion() sqlcmdVersion()
Check bcp and sqlcmd versions
createTable() dropTable() checkTableExists()
Create or drop table
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.