(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?
(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.
Primavera version 20.12
Is there a method to make a copy from Oracle Database (Schema) and reconfigure it in case of any issues in the original database (Schema) ?
Printer-friendly version
Send to friend
the migration tool works if the going from MS SQL to MS SQL very good but if the versions are too far apart then you can not convert an Oracel SQL to a MS SQL says version 8.2 to version 21
I wonder how easy the process is and why nobody knows about the migration tool.
The Primavera database folder contains this file < migrate.bat >
When you open it you will get a powerfull tool that you can use it to:
In addition to :
Migrate the P6 database from P6 professional to P6 EPPM.
I wonder how easy the process is and why nobody knows about the migration tool.
The Primavera database folder contains this file < migrate.bat >
When you open it you will get a powerfull tool that you can use it to:
In addition to :
Migrate the P6 database from P6 professional to P6 EPPM.
you are backing up the entire database not an individuals users database that is unless you created several databases
Hi Zoltan,
Thank you for your detailed answer.
It will be really appreciated, if you could share your knowledge about how we can make a copy of individual schema of oracle XE database.
Your answer will back up the entire XE database where this database has many (schemas) for example for Admuser, Admuser1, Admuser2, ............ etc.
The question is how we can make a copy from <Admuser Shcema> which is a part of the entire XE database.
Thank you again for your time.
are you talking about the oracle databse or the SLQ database ? which one are you using ?
if it is oracle then
In Oracle Database XE, the database backup and recovery facility is based upon the Recovery Manager (RMAN) utility that is integrated into the database. Oracle Database XE includes backup and restore scripts that you access using menu choices on your desktop. These scripts perform a full backup and restore of the entire database, and store backup files in the flash recovery area.
To back up the database:
1. Log in to the Oracle Database XE host computer as a user who is a member of the ORA_DBA user group. This is typically the user that installed Oracle Database XE.
2. Click Start, point to Programs (or All Programs), point to Oracle Database 10g, and then select Backup Database. A console window opens so that you can interact with the backup script.
If running in ARCHIVELOG mode, the script displays the following output:
Doing online backup of the database.
If running in NOARCHIVELOG mode, the script displays the following output:
Warning: Log archiving (ARCHIVELOG mode) is currently disabled. If you restore the database from this backup, any transactions that take place between this backup and the next backup will be lost. It is recommended that you enable ARCHIVELOG mode before proceeding so that all transactions can be recovered upon restore. See the section 'Enabling ARCHIVELOG Mode...' in the online help for instructions. Backup with log archiving disabled will shut down and restart the database. Are you sure [Y/N]?
3. If prompted, enter y and press Enter to confirm the database shutdown and begin the backup.
After the backup is complete, the script displays the following output:
Backup of the database succeeded.
Log file is at <location>
Press ENTER key to exit
where <location> is the location of the log file.
4. Press Enter to close the Backup Database window.
Logs containing the output from the last two backups are stored in the following location:
C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\OXE_BACKUP_CURRENT.LOG.
C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\OXE_BACKUP_PREVIOUS.LOG.
When the backup is complete, the backup files are stored in C:\oraclexe\app\oracle\flash_recovery_area\XE\
IF it is microsoft SQL then use something like SLQ Management Studio
Log in as SA
password: Prima123Vera
on the left find ytour database might be PMDB
Righ click on the database
then tasks
then backup
choose your backup type and the location
click OK
Email: PPadmin@planningplanet.com
Replies