makeConnectArgs: Create a named list of connection arguments to translate to...

In bcputility: Wrapper for SQL Server bcp Utility

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

Description

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

bcputility documentation built on June 22, 2024, 11:55 a.m.