compareVocabData: Compare two vocabularies

Description Usage Arguments

Description

This function enables you to compare two vocabularies at the row level.

Usage

1
2
3
4
compareVocabData(connectionDetails, cdmDatabaseSchema,
  oldVocabularyDatabaseSchema = cdmDatabaseSchema,
  newVocabularyDatabaseSchema, findPrevalences = FALSE,
  oracleTempSchema = NULL)

Arguments

connectionDetails

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

cdmDatabaseSchema

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

oldVocabularyDatabaseSchema

The name of the database schema that contains the old vocabulary instance. Requires read permissions to this database. On SQL Server, this should specifiy both the database and the schema, so for example 'cdm_vocab.dbo'.

newVocabularyDatabaseSchema

The name of the database schema that contains the ewvocabulary instance. Requires read permissions to this database. On SQL Server, this should specifiy both the database and the schema, so for example 'cdm_vocab.dbo'.

findPrevalences

A boolean flag to indicate whether or not run FetchPrevalences.sql

oracleTempSchema

For Oracle only: the name of the database schema where you want all temporary tables to be managed. Requires create/insert permissions to this database.


OHDSI/Tantalus documentation built on May 3, 2019, 3:39 p.m.