There are some limitations when you extract or load data from
a .data file to a table or view using the workbench.
- Object, array, structure and reference data are not supported. These values
are replaced by NULL when you extract data to a .data file.
- The behavior of the extract and load features vary depending on the JDBC
driver you are using to connect to a particular database. Depending on the
limitations of the JDBC driver, some types of data may 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 may not load successfully. If you want to perform
this kind of operation, it is your responsibility to 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, it is your responsibility to ensure that
the delimiters do not conflict with the data.