Skip to content

v0.4.0

Compare
Choose a tag to compare
@tomroh tomroh released this 01 Apr 14:30
· 27 commits to main since this release
293b762
  • 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.