Added documentation for bcp versions that do not support trustservercert
Updated documentation for bcpOptions so it is clear how to use command line arguments that have spaces.
Updated readme to clarify dependencies and provide quick start examples.
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.
Override/set path to sqlcmd with
options(bcputility.sqlcmd.path = "<path-to-sqlcmd>")
Added bcpVersion and sqlcmdVersion 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 and bcpExport 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 and bcpExport 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, and checkTableExists have been added for
internals and convenience. The primary purpose would be to define an empty
table with user-defined types that bcpImport could append to.
logicals no longer need to be converted from FALSE/TRUE to 0/1 before
importing in-memory data.
The argument azure was added to bcpImport and bcpExport for Azure
Active Directory authentication. This only works for username and password
authentication.
bcpImport now returns the output of system2 for all specifications of
stderr and stdout
added documentation for using schema and DBI::Id is now supported
trusted 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 platforms
added check to see if bcp program can be found
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 memory
Added support for geometry/geography data import for 'sf' objects
NEWS.md file to track changes to the package.bcpImport to import data to SQL ServerbcpExport to export data from SQL Server