To perform an unattended migration from Oracle XE to SQLite, complete the following steps:
- Navigate to the folder in which P6 Professional is installed. For example C:\Program Files\Oracle\Primavera P6\P6 Professional.
- From the command line, run Primavera.SQLite.MigrateUI.exe with the following flags set:
-s oraclexe
-dbname <//server:port/service name>
-adminuser <database admin user name>
-password <database admin user password>
-filename "<sqlite db file name>"
For example, to perform an unattended migration from Oracle XE to SQLite:
Primavera.SQLite.MigrateUi.exe -s oraclexe -dbname //localhost:1521/xe -adminuser admin -password admin123 -filename "C:\data\pmdb_sqlite.db"
Note: If the specified SQLite database file does not exist, the Standalone Database Migration Tool automatically creates the file.
After migrating a standalone database, you must run Database Configuration to create a database connection for the new SQLite database. See Running Database Configuration After Upgrading for details.