It may be helpful to be able to easily copy a small test cdm from a local database to a remote for testing. copy_cdm_to takes a cdm object and a connection. It copies the cdm to the remote database connection. CDM tables can be prefixed in the new database allowing for multiple cdms in a single shared database schema.
Usage
copy_cdm_to(con, cdm, schema, overwrite = FALSE)
copyCdmTo(con, cdm, schema, overwrite = FALSE)
Arguments
- con
A DBI datbase connection created by
DBI::dbConnect
- cdm
A cdm reference object created by
CDMConnector::cdmFromCon
orCDMConnector::cdm_from_con
- schema
schema name in the remote database where the user has write permission
- overwrite
Should the cohort table be overwritten if it already exists? TRUE or FALSE (default)