Load Vocabulary Tables From a Preexisting Schema.

This function populates all Vocabulary tables with data from Vocabulary tables in a specified schema.

LoadVocabFromSchema(connectionDetails, cdmSourceSchema, cdmTargetSchema)

Arguments

connectionDetails

An R object of type
connectionDetails created using the function createConnectionDetails in the DatabaseConnector package.

cdmSourceSchema

The name of the database schema that already contains the Vocabulary tables to copy. Requires read permissions to this database. On SQL Server, this should specifiy both the database and the schema, so for example 'cdm_instance.dbo'.

cdmTargetSchema

The name of the database schema into which to copy the Vocabulary tables. Requires read and write permissions to this database. On SQL Server, this should specifiy both the database and the schema, so for example 'cdm_instance.dbo'.

Details

This function assumes
createCDMTables() has already been run and
cdmSourceSchema has all required Vocabulary tables.