To perform an unattended migration from Microsoft SQL Server Express Edition 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 sqlexpr
-dbname <sql server instance name>
-host <sql server host,port>
-adminuser sa
-password <sa user password>
-filename "<sqlite db file name>"
For example, to perform an unattended migration from Microsoft SQL Server Express Edition to SQLite:
Primavera.SQLite.MigrateUi.exe -s sqlexpr -dbname PMDB -host localhost,1433 -adminuser sa -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, run Database Configuration to create a database connection for the new SQLite database. See Running Database Configuration After Upgrading for details.