Backup primavera p6 oracle database
- #Backup primavera p6 oracle database driver
- #Backup primavera p6 oracle database professional
- #Backup primavera p6 oracle database free
Inside the ‘Maintain Baselines’ dialog box we select the oldest baseline from the list and click on the ‘Restore’ button which is on the right-hand side, as shown in Figure 3. To restore a baseline, first, we select ‘Maintain Baselines’ from the ‘Projects’ menu, as shown in Figure 2. Figure 1Īs a rule of thumb when we get to more than 3 baseline snapshots, we can restore the oldest (snapshots) as a project. As you will notice in the ‘Maintain Baselines’ dialog, over nine weeks we have added nine copies of our entire project progress to the database. In Figure 1 below, we have our construction project which is being updated weekly.
#Backup primavera p6 oracle database free
How can you keep the database free of clutter whilst still maintaining a historical record of your project status using the baseline snapshot feature in Primavera P6? Let’s take a look at how you can backup Primavera P6 baselines. This unnecessary clutter will eventually slow down the database. In reality, a whole copy of your project will be added to an already messy P6 database. Whilst updating a project weekly, you may be required to keep a snapshot every time you use the ‘Maintain Baseline’ feature in Primavera P6. It’s quick and easy when you choose to use the P6 SQLite database for your standalone system.Many Primavera P6 databases become cluttered with a myriad of items, ranging from old redundant codes to more copies of projects than are ever required in anyone’s lifetime.
#Backup primavera p6 oracle database professional
In just a couple of minutes you can create a sandbox database for your Primavera P6 Professional client. Once you enter P6 Professionals you can go to the Admin menu and click on Admin Preferences to set a preferred Industry to avoid seeing this prompt again. You will see the following prompt the first time you login to your new sandbox database. Now you can login to Primavera P6 in the normal way being sure to select your new sandbox database in the Database field. In the Connection Successful dialog, click Finish. Having modified the SQLite database file name, click Next. If you want a clean database, you can simply uncheck this box before your click the Next button. This loads a bunch of sample projects, resources, calendars, layouts and other data that you may want to have for learning purposes. Note: you can also choose to “ Load Sample Data” as part of this process using the so-named check box. In the example we changed it to PPMDBSQLite_sandbox.db. You do this simply by typing changes to the.
In the next dialog, modify the default name of the PPMDBSQLite.db file so that you do not overwrite any existing SQLite database files. In the next dialog, enter and confirm a new administrator password, then once again click Next. In the ‘ Configure P6 Professional Standalone Connection’ dialog, choose the “Add a new standalone database and connection” option, then click Next.
#Backup primavera p6 oracle database driver
Next select the P6 Pro Standalone (SQLite) option in the Driver Type field. In this example we called it SQLite_Sandbox. In the Database Configuration dialog, enter a name for your new sandbox database alias in the Database Alias dialog. In the resulting Edit Database Connections dialog, click the Add button. In this dialog, click the ellipse button on the Database field. Here are the steps to set up a P6 SQLite database – and they are gloriously simple.įirst, run up the Primavera P6 application to access the login dialog. Now however, the terrain is accessible to those of us who may not have advanced degrees in database administration thanks to the introduction of P6 SQLite database.
You may have used such tools as Oracle XE or Microsoft SQL Express to create additional databases. Previously one would have had to goof around with SQL scripts, the dbsetup.bat tool. This is because they very wisely introduced an P6 SQLite database option to the system. In recent years this process has been made really easy by Primavera. Sometimes it’s useful, or even necessary to create a sandbox database to play around in for your P6 Professional client software.