Skip to content

copy ing the Project database??

Mirza Imam BaigMember for 23 years 5 months
Created
6
2
0
Gentlemen,

can anyone guide me how to copy the complet Project database from computer to another for P3e/c 5.0

Thanks for your responses.

Imam Baig

6 replies

Oldest first
  1. 0
    Marcio Sampaio ·
    Are u using P3e or P5??

    Is it a local database or a SQL/Oracle??

    But if u want to transfer data base of only one Project, just export it.

    Regards.
  2. 0
    JK Morris ·
    Well this isn’t my question, but I would like to know how to copy a MSDE database that resides on my laptop for backup purposes.

    It contains a few layers of EPS nodes and several projects so exporting would be very tedious.

    Thanks,
    John
  3. 0
    Bill McMichael ·
    MSDE database file is in-use by the database server at all times. This means a file based backup utility will not backup the database correctly. You must use a tool specifically made to backup SQL Server/MSDE database.

    The following soltuons are provided in the Primavera Knowledge base -- Solution ID: prim27893.

    1. Use OSQL, which is an MSDE command line utility.
    2. Use MSDE backup utility created for Contractor that will also work for Primavera 5.0. This can be downloaded from Primavera’s knowledge base.
  4. 0
    Mirza Imam Baig ·
    It’s P5 and it’s a local database... please advise
  5. 0
    Bill McMichael ·
    Please see my previous post. Refer to Solution ID: prim27893 and there are two solutions posted there.

    Or if you Google "Backup MSDE", there are others. Key point is you cannot simply copy files for SQL Server / MSDE database to properly back it up.
  6. 0
    Karim Mounir ·
    for backing up your database in P5 (SQL), u logon to the SQL server and then to "Programs"-->"Microsoft SQL Server"-->"Enterprise Manager" then u choose "Databases" and then right click on your databse and "All Tasks"-->"Backup database" and then select where u want to put the 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?