bcputility (version 0.4.3)

makeConnectArgs: 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
)

Value

a list with connection arguments

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.