There are some limitations when you extract or load data from
a .data file to a table using the workbench.
- Object, array, structure and reference data are not supported. These values
are replaced by a null value when you extract data to a .data file.
- The behavior of the extract and load features varies depending on the
JDBC driver that you are using to connect to a particular database. Depending
on the limitations of the JDBC driver, some types of data might not extract
or load successfully.
- If you extract data from a table or view of one database vendor and version,
and then attempt to load the data into a table or view of another database
vendor or version, the data might not load successfully. If you want to perform
this kind of operation, you must ensure that the extracted data is compatible
with the database that you intend to load the data into.
- When you specify column and character string delimiters in the Extract
Data window or the Load Data window, you must ensure that the delimiters do
not conflict with the data.