Try OpenEdge Now
skip to main content
Database Administration
Maintaining and Monitoring Your Database : Multi-tenant database : Tenant Data Recovery : Step 3: Moving data with PROUTIL DATAMOVE
 
Step 3: Moving data with PROUTIL DATAMOVE
The third step in the tenant data recovery process is to move data from your temporary database to your production database.
Once you have a temporary database restored from backup and rolled forward, you can use it as the source database for recovering your deleted data. You move data into your production database with PROUTIL DATAMOVE. You can issue a complete DATAMOVE from the command line, or you can invoke the menu-driven user interface, provided the target and source databases are running in multi-user mode.
A single command line data move allows you to move data for one tenant or group. For a tenant, you can move table data or a sequence; for a group, you can move table data.
Depending on the data you need to recover, choose one or more of the following options to PROUTIL DATAMOVE:
*Move one table with the DATAMOVE command line
*Move one sequence with the DATAMOVE command line
*Move multiple tables and sequences with the DATAMOVE userinterface
By default, PROUTIL DATAMOVE, moves data by bundling 100 records in a single transaction. You can change the number of records per transaction on the command line with the recs parameter, or with Option 4 of the user interface.
See PROUTILDBRESTRICT qualifier for the complete syntax.
* Move one table with the DATAMOVE command line
* Move one sequence with the DATAMOVE command line