About the data export or import

[nuny]

compared with the commecial universal database tool , such as dbvisualizer, the function of data export or import is a weak point.
for example ,it cant import data from text file . but it still an excellent tool. And I think the function of data export or import can be done by kettle, a etl tool.

[Serge]

Hello,

Actually you can import text file (I assume you mean some kind of CSV) into table. Currently it is not so easy as in some commercial tools but it works.
Data transfer wizard support export to any external format (csv, xml, etc) but it can import only from existing table.
So first you need to create CSV file connection (using Flat Files/CSV driver) and thus map you text file to table.
Then right click on this table and choose Data Export item. Use Database export format. Also you may export directly from result set (choose Data Export in context menu).

Direct CSV import is in TODO list and will be added in one of future versions.

Thanks