bcputility 0.4.3
An error is now thrown for cases where a projection has an EPSG that is
NA
.Added ability to turn on QUOTED_IDENTIFIERS. This is required for some Microsoft database products. Use the bcp “-q” option.
Column names are quoted so that reserved words can be used.
bcputility 0.4.0
CRAN release: 2023-01-16
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. UsemakeConnectArgs
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.
bcputility 0.3.0
CRAN release: 2022-02-20
bcpImport
now returns the output of system2 for all specifications of stderr and stdoutadded documentation for using schema and
DBI::Id
is now supportedtrusted connections are now compatible with newer sql server drivers as the default for all drivers is now
trusted_connection='yes'
user name and passwords are now quoted with
shQuote
so special characters are handled across platformsadded check to see if bcp program can be found
bcputility 0.2.0
CRAN release: 2021-08-06
set the path to the bcp utility with the bcputility.bcp.path option
added links to source code, bug reports, and documentation site
rowterminator and fieldterminator are no passed to
data.table::fwrite
if data is in memoryAdded support for geometry/geography data import for ‘sf’ objects