Solution ID: prim80787
How to move the standalone setup from one workstation (Machine A) to a server (Machine B) that will be using Full SQL 2005
Status: Reviewed
Version(s): 6.0, 6.1, 6.2, 6.2.1

Problem: How to move the standalone setup from one workstation (Machine A) to a server (Machine B) that will be using Full SQL 2005.
Problem: How to move the P6.* standalone setup from one workstation (Machine A) to a server (Machine B).
Problem: Move Standalone to Client / Server setup.
Problem: Move P6 Standalone Installation.
Fix: 1) Backup the database(s) from the old workstation.

      The following solution will provide a set of instructions to backup/restore SQL databases:  Solution ID:  prim54984  How to backup and restore a SQL 2005 Express Database


2) Create privuser/pubuser account


3) Restore the database and resync the privuser/pubuser account(s) :


The following solution will provide a set of instructions to backup/restore SQL databases:  Solution ID:  prim54984  How to backup and restore a SQL 2005 Express Database


4) If your restored database name is not pmdb$primavera, you may need to reconfigure your database alias to point to the new database name.


      The following solution will provide a set of instructions to create a database alias:  Solution ID:  prim31108  How to create a database alias for Project Management


      Note:  The solution can also be used when configuring a database alias to Methodology Management.