Avatar of Errol Farro
Errol Farro
Flag for Aruba

asked on 

Copy As400 table to SQL server

Does anyone know the best (fast) way to copy a As400 table to a SQL table.

Currently using the following format which makes a the copying of millions of records slow.


<cfloop query=x>

            <cfquery name=sql_qry datasource=sqlDS>

                        INSERT INTO Table1(id, name) VALUES(#x.id#, #x.name#)




Copying the contents or the complete table at once will do.

Web Development SoftwareMicrosoft SQL ServerIBM System i

Avatar of undefined
Last Comment
Theo Kouwenhoven

8/22/2022 - Mon