Releases: tomroh/bcputility
v0.4.3
v0.4.0
-
Override/set path to sqlcmd with
options(bcputility.sqlcmd.path = "<path-to-sqlcmd>")
-
Added
bcpVersion
andsqlcmdVersion
to check versions. -
Specify tables without schema strictly as a character vector of size 1 e.g.
"<schema>.<table>"
. The schema and table will be quoted although special
characters are not recommended except for "_". -
Tests have been added that can run against a local instance of SQL Server.
These do not work without it as SQL Server is a client/server configuration. -
The README has been updated for new syntax and updated benchmarks.
-
bcpImport
andbcpExport
gain a bcpOptions argument that allows the user
to include any options from the CLI. See documentation for formatting and
specification. -
The connections arguments for
bcpImport
andbcpExport
have been
deprecated--server, database, username, password, trustedconnection. Use
makeConnectArgs
for the connectargs argument which adds Azure AD
authentication and the option to disregard the trust server certificate. -
The "DBI" dependency has been dropped and all SQL Server queries are run
using bcp or sqlcmd. -
mapDataTypes
is a convenience function to determine SQL Server data type
conversions. The defaults attempt to determine the smallest type size for
each column. -
createTable
,dropTable
, andcheckTableExists
have been added for
internals and convenience. The primary purpose would be to define an empty
table with user-defined types thatbcpImport
could append to. -
logicals no longer need to be converted from
FALSE/TRUE
to0/1
before
importing in-memory data. -
The argument azure was added to
bcpImport
andbcpExport
for Azure
Active Directory authentication. This only works for username and password
authentication.