My Oracle Support Banner

How to Move a P6 Database to a New Microsoft SQL Server (Doc ID 1401226.1)

Last updated on JUNE 04, 2019

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.2.1 and later
Primavera P6 Professional Project Management - Version 6.2.1 and later
Generic Windows
Affected Database: Microsoft


Goal

The purpose of this document is to explain the steps necessary to move a P6 PPM and EPPM database to a new SQL Server

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 1) Backup your P6 database
 2) Add the users manually in your new SQL Server
 3) Restore your P6 database in your new SQL Server
 4) As SA in SQL Server Management Studio, run sync script for all users
 5) (Optional) As SA in SQL Server Management Studio, run the following scripts in your P6 database
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.