R/bcp.R
makeConnectArgs.Rd
Create a named list of connection arguments to translate to bcp and sqlcmd options
makeConnectArgs(
server,
database,
username,
password,
trustedconnection = TRUE,
trustservercert = FALSE,
azure = FALSE,
quotedidentifiers = FALSE
)
the instance of SQL Server to which to connect
specifies the database to connect to
login ID
password for login ID
use integrated security, username and password are not required
trust the server certificate
use Azure Active Directory authentication, does not work with integrated authentication.
set QUOTED_IDENTIFIERS option to 'ON' for the connection between bcp/sqlcmd and SQL Server.
a list with connection arguments