Transferring Data

The following table lists several data transfer scenarios, along with suggestions on the utilities to use to accomplish the task. These utilities are fully documented in the System Utilities Reference Guide.

Use	To
dbdump -d and dbload	Copy all the data from a specific data area or data ID of a product line into the same data area or data ID in a different product line.
expsysdb and impexp	Copy data from all data areas of a product line (or all files of a given application) to the same data areas in a different product line, including any related attachment files.
dbcopy	Copy data from one data area to another.
An application Import/Export program or custom program, and impexp	Copy data from only a few or several selected data area files, with data meeting a desired set of selection criteria.
CSV file (created by either rngdbdump or by some other method) and importdb	Copy CSV-formatted data area files to a Lawson database file. CSV files are also called comma-delimited files.
lashow from the displayed report; select the CSV File option from the Send (F8) menu.	Copy Lawson report data to a spreadsheet.
Paint, generate, compile, and run the desired report using Environment 4GL, and display the report. From lashow, select the CSV File option from the Send (F8) menu.	Transfer custom report data to a spreadsheet.
gendbload	Copy all data from a specific data area or data ID of a product line into the same data area or data ID in a different product line, overriding the product line.
jobdump jobload	Copy jobs from the GEN database of one Environment to the GEN database of another Environment.