Skip to content

Adding "sandpit" database

Melanie EastoeMember for 20 years 3 months
Created
5
2
0
I have just completed a P3e training course and am brand new to the whole project management scene. Can anybody offer some advice or instructions how I can create a "sandpit" database for practice/training to avoid corrupting my main data?
regards,
mel

5 replies

Oldest first
  1. 0
    Sanjiv Parekh ·
    when you click on p3e icon it will open up dilog box. click on PMDB database ...likck and create new PMDB databse and call it test or sandpit for play around
  2. 0
    Kevin Button ·
    Sanjiv

    Doing this will only add a database alias, it does not create a new database. If you do this you could end up deleting or changing important data in the belief that you are working in a safe area.

    A sandpit is simply another database, installed the same way as your live database, and once this has been installed you can then create an alias in Project Manager to point to the sandpit.

    Cheers
  3. 0
    Frank Borcherdt ·
    Melanie,

    You need the first P3 CD and let it autorun (or double click on autorun.exe if it does not) then choose Install Other Tools then Server Databases. Program will lead you through creating a new database and you then need to configure it as described below.

    If you are not running stand-alone, I would suggest you speak to your DBA about creating the database on the server.

    The admin guide on the docs CD has a good description on how to set up databases for both Oracle, MS-SQL and stand-alone.
  4. 0
    Melanie Eastoe ·
    Thanks guys... have since discovered my software was not installed complete on my pc, CDs are on their way to rectify this - Primavera rep is assisting me.
    Mel
  5. 0
    Emma Seaton ·
    You might find it easiest just to set up ’Sandpit’ under the EPS as a section heading and put all your test projects under it. This was available this way on a CITRIX based P3e and i’ve set it up on my standalone version too. If you don’t want the test projects to show up in reports or summaries set them to inactive or planned in the Projects window. I don’t see how they can corrupt other data in the database - then again i’ve not come across any corrupt data yet....?? ;o)

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?