Skip to contents

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