Inserting large set in Toad Data Point ver 3.2


I am in the process of loading data into Sql Server. Mostly I have to deal with files that have ‘Insert into …’ statements.

One file have over 1 mln records. I cannot load into Editor tab. Is there a way in TDP to execute a script without loading it into editor ?



I recently had to perform a similar task. I had the data set as a CSV file, and used import wizard to import into MySQL without any issues.


I will have to export into CSV then. I tried to use automation but it still attempted to load a content of the file into the “mini” editor window and the TDP froze afterwards.