There are three restrictions for using the Dump and Load option from the OpenEdge Data 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 using such ABL statements 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: OpenEdge RDBMS table data can also be dumped and loaded in formats other than those described in this chapter.
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 using such ABL statements as INPUT FROM, CREATE, and IMPORT.