Progress
Database Administration
Guide and Reference
Dump and Load Limitations
There are three restrictions for using the Dump and Load option from the 4GL tools:
- When you reload data from one database to another, the reload must be to a target database that has the same fields, arranged in the same logical order as the source database. The schema for each database must be identical. Otherwise, you must write your own reload procedure. You can use 4GL statements such as INPUT FROM, CREATE, and IMPORT.
- If you define a database field with a data type of ROWID or RECID, then the ROWID values in that field are dumped and reloaded as unknown value (?). You must write your own dump and reload procedures to accommodate ROWID fields.
- If you do not have Can-Create and Can-Write privileges for a file, you can still dump the data and data definitions for that file. You can also load the data definitions for the file, but you cannot load the data for that file.
NOTE: Progress can also dump and load table data in formats other than those described in this chapter. For information about other file formats Progress can dump and load, see the EXPORT and IMPORT statements in the Progress Programming Handbook .
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |