Primavera (MOSC)

MOSC Banner

How to Move a P6 Data Base to A New Microsoft SQL Server...having problem with KB (Doc ID 1401226.1

edited Oct 7, 2013 3:41AM in Primavera (MOSC) 1 commentAnswered

In the KB "

a) Browse to <Database Media Folder>\scripts\upgrade\PM_<DB_Version>
b) Run sspm_grants.sql
c) Run sspm_synonyms.sql
d) Browse to <Database Media Folder>\scripts\source\PM_<DB_Version>
e) Run sspm_src.sql script

I have successfully followed steps 1-4 (backing up, restoring the DB, running the step 4 script.. but I cannot figure out where to go/what to click on to run the step 5 scripts (its all in SQL Express 2005 on a Laptop).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center