I’m a migration consultant at Infor (Infor and Microsoft have a partnership) and we use in case the target database is SQL Server the bcp.exe to upload the data from old Baan-systems and legacy-systems into our core product “Infor ERP LN”.
The big, big problem with the bcp.exe is that loading stops as soon as a duplicate record exists. Is it possible to extend the bcp.exe to be able to load in append- and conventional mode like Oracle sql loader?
This is the big advantage of the Oracle High performance loader (sqlldr) where you can load the data in Conventional mode which creates the records per row!
I also heard that the bcp.exe will be replaced in future by another utility. We really hope this new utility don’t stop by each duplicate! Maybe you can provide me with more details about the new utility?
Many thanks in advance!
View Complete Post