Valentina Studio inset a millions of rows

Question

I have txt file with insert statements with few millions of rows. I want to insert them inside database, but I can't copy and paste in Valentina because it is too much for SQL window.

How do I insert in batch from a file?

Answer 1

Valentina Studio has command "Load Dump...", which can load big files with any SQL commands, including inserts.

You can find this command in the menu File or in the contextual menu of a Database object in the Schema Editor.