Import of General Journal in SQL takes excessive time

ghoover

I am dataporting a 5000 line general journal into SQL database and it is taking 10 hours. Importing into a C\SIDE database takes 1/2 hour.

Any suggestions for improving?

Fredrik_Gustafsson

Try to write the import in a codeunit instead of dataport. Requires a bit more coding, but should be faster.