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

Usage

makeConnectArgs(
  server,
  database,
  username,
  password,
  trustedconnection = TRUE,
  trustservercert = FALSE,
  azure = FALSE,
  quotedidentifiers = FALSE
)

Arguments

server: the instance of SQL Server to which to connect
database: specifies the database to connect to
username: login ID
password: password for login ID
trustedconnection: use integrated security, username and password are not required
trustservercert: trust the server certificate
azure: use Azure Active Directory authentication, does not work with integrated authentication.
quotedidentifiers: set QUOTED_IDENTIFIERS option to 'ON' for the connection between bcp/sqlcmd and SQL Server.

Value

a list with connection arguments