Skip to content

transferring oracle XE database to new computer

Chris SawatskyMember for 10 years 10 months
Created
5
5
0

Hello,

I am replacing a computer for a Primavera P6 PM user, and trying to get his data moved over. From my understanding if we just export to XER file there are some components that will not transfer, such as baseline and historical data. 

I am proficient in MSSQL and other SQL flavors, and I'm very good at googling up information but have been beating my head against this Oracle XE engine for several hours and I think I am actually further behind than when I started. 
 

Can someone either spell out or link to very comprehensive instructions on backing up and restoring to new hardware? The oracle XE installs are identical on both computer. I've run the backup script and attempted to transfer what I believe is the backup file to the new machine, but the instructions are all incredibly vague. 

 

thanks for your help! 

5 replies

Oldest first
  1. 0
    Zoltan Palffy ·

    please see my post here this

    please see my post here this will get you what you are looking for 

    http://pmsite.com/forums/viewthread/3382/

     

     

  2. 0
    Chris Sawatsky ·

    this looks like great

    this looks like great instructions, thanks! not sure why I was unable to come up with it via google

     

    one thing however, I can't seem to find the script you've mentioned, xe_expimp.zip

     

    could you provide a link?

     

    thanks again

  3. 0
    Chris Sawatsky ·

    double post

    double post

  4. 0
    Zoltan Palffy ·

    yeah Chris double post I knoe

    yeah Chris double post I knoe becuase it did not show up the first time 

  5. 0
    Zoltan Palffy ·

    check the post again I added

    check the post again I added the zip file 

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?