After upgrading the schema of your existing P6 Professional database with the Standalone Upgrade Utility, you can use the Standalone Database Migration Tool to migrate the database from Oracle XE or Microsoft SQL Server 2005 Express Edition SP3 to SQLite.
Note: The P6 Professional Standalone Database Migration Tool migrates a P6 Professional Standalone Database to SQLite from the following database platforms and schema only:
- OracleXE
- Microsoft SQL Server 2005 Express Edition SP3
It will not migrate a P6 Professional Standalone Database from any of the following:
- Full Oracle database platform
- Full SQL Server database platform
If you selected the Run Standalone Database Migration Tool option during installation, the Standalone Database Migration Tool launches automatically after P6 Professional installation is complete. You can also run it manually at any time.
To run the Standalone Database Migration Tool, complete the following steps:
- If Database Configuration does not launch automatically, click Start, All Programs, Oracle - Primavera P6, P6 Professional <release level>, P6 Professional <release level> Help and Tools, P6 Professional Standalone Database Migration Tool.
- In the Database field, select the database alias for your existing standalone database.
- In the Password field, enter the sa password for the existing standalone database.
- In the Administrative user name field, enter the administrative user name for the existing standalone database.
- In the File name field, click the Browse button and go to the location for the new SQLite database.
- Click Migrate.
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 Installation for details.