Can DbVisualizer import table tata from a .sql file?

Question

It seems that the only supported import data file format is .csv?

http://www.dbvis.com/doc/9.0/doc/ug/exportImport/exportImport.html

score 1 · Answer 1 · answered Oct 22 '14 at 19:52

1

If you have a .sql file with insert statements it can be executed in DbVisualizer as-is. Just load the script in the SQL editor and run the script to execute the insert statements.

answered Oct 22 '14 at 19:52

roger

641
4
7

If you have a big file, you can do it in that way – Federico Traiman Jul 05 '17 at 16:14
5

For really big sql files, use the @run command in the SQL Commander. – roger Jul 06 '17 at 19:20
`@run` takes around 18 seconds per 1000 inserts to my remote server, even in a transaction. But it works. – Noumenon Nov 17 '18 at 18:33

Can DbVisualizer import table tata from a .sql file?

1 Answers1