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

roger · Accepted Answer · 2014-10-22 19:52:46Z

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, 2014 at 19:52

roger

6494 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Federico Traiman Over a year ago

If you have a big file, you can do it in that way

roger Over a year ago

For really big sql files, use the @run <file.sql> command in the SQL Commander.

Noumenon Over a year ago

@run takes around 18 seconds per 1000 inserts to my remote server, even in a transaction. But it works.

Collectives™ on Stack Overflow

Can DbVisualizer import table tata from a .sql file?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related