Toad World® Forums

Inserting large set in Toad Data Point ver 3.2


#1

Hello,

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 ?

Thanks

Chris


#2

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.


#3

Ok,

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.