DATABASE -BULK INSERT

DATABASE -BULK INSERT

  
hello

Want to know ,how can we insert bulk records into database table .like SQLbulk in .net or other applications



Arpita



Hi Arpita,

The platform doesn't have any provision for this. You'll need to write an extension if you really need it.
There are more threads about it (search for it) and it's doable quite easy.
And yes, you have to create an extension for it.
The AsynchronousLogging extension already does this.

The downside is that the call ALWAYS returns successfully, which means that you do not get the ID of the created row or any error messages if the row could not be written (data too long for field, constraint violations, etc.). But that's to be expected with any bulk INSERT method.

J.Ja
Hello Justin

I didn't find any AsynchronousLogging extension on forge .Can you plz tell me where to find it?

Arpita
Hello All

Actually i am going to insert all excel records in database at one shot at run time.
So the AsynchronousLogging  extension  can do it .
and where can i find it .please suggest.


Arpita


Hi Arpita,

It's a system component, so you already have it available.

okay..but again i need to iterate as i want to insert bulk record in one go.
This extension takes input only one record at a time.

I have recordList.
If you have other options plz suggest.

Arpita 

okay got it will save the records in a message queue and save afterwards and give performance 

thanks all
Hi Arpita,

The extension itself will do that. You don't need to buffer them yourself. What the extension does is save the input, and put everything in the database when it feels it's convenient. So don't go queuing yourself!