Migrate Database
The migrate-database command migrates a Smile CDR database to the latest schema.
A typical Smile CDR installation will have two sets of tables:
In the default Smile CDR configuration, both the Cluster Manager and the FHIR Storage tables are placed in the same database schema. It is possible to configure Smile CDR to use different schemas/users for each, or even to have multiple separate schemas. The examples below assume the default configuration.
The following example shows the command in action:
# Migrate the Cluster Manager
bin/smileutil migrate-database --driver POSTGRES_9_4 --from V2018_05_R01 --to V2018_09 --mode CLUSTERMGR --url "jdbc:postgresql://localhost/cdr" --username MYUSER --password MYPASS
# Migrate the Persistence Module
bin/smileutil migrate-database --driver POSTGRES_9_4 --from V2018_05_R01 --to V2018_09 --mode PERSISTENCE --url "jdbc:postgresql://localhost/cdr" --username MYUSER --password MYPASS
-d [driver] (or --driver [driver]) – This argument tells the tool which database dialect to use. The values used here are identical to the values used in the Smile CDR configuration properties file.-n [username] (or --username [username]) – The database username.-p [password] (or --password [password]) – The database password.-u [url] (or --url [url]) – The JDBC database URL.-m [mode] (or --mode [mode]) – Specifies whether the cluster manager (CLUSTERMGR) or FHIR Storage (PERSISTENCE) module tables should be migrated, or both (CLUSTERMGR_AND_PERSISTENCE). In a typical Smile CDR installation these tables will both exist in the same database schema, so this command may be run once for each or by using the combined option. Some installations may separate these into separate schemas, or may not have FHIR Storage tables at all.-f [from] (or --from [from]) – The Smile CDR Version to migrate from.-t [to] (or --to [to]) – The Smile CDR Version to migrate to.-r (or --dry-run) – (optional) If included, instructs smileutil to perform a dry run, where no changes are made.Note that many of the options above require an argument from a list of possible values (such as the Database Driver and the Smile CDR Version. You can see a list of possible options by using the following command:
bin/smileutil help migrate-database
Migrating the default H2 database setup:
bin/smileutil migrate-database -d H2_EMBEDDED -u "jdbc:h2:file:./h2_database/h2_clustermgr;create=true" --username "SA" --password "SA" -f V2019_08 -t V2019_11 -m CLUSTERMGR_AND_PERSISTENCE -r