About the data export or import

Feature requests and their debate

About the data export or import

Postby nuny » Sun May 05, 2013 12:10 am

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.
nuny
 
Posts: 1
Joined: Sun May 05, 2013 12:03 am

Re: About the data export or import

Postby Serge » Sun May 05, 2013 7:22 am

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
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Feature Requests



Who is online

Users browsing this forum: No registered users and 2 guests