Hello everyone,
I have a unique situation, or at least I believe it to be. We are looking to add roughly 500K+ items to our GP 9. We have macro the procedure but due to some small scale testing, we believe that the macro would take hundreds if not thousands of hours to complete and that is not accounting for the breaks as we would have to divide the macro up for performance reasons.
My next thought was to instead add these items via SQL. I started by running the macro in our test environment and running SQL Profiler to catch the save actions. Unfortunately, this hasn't worked to well as it seem only selects are taking place.
I am wondering if anyone has had experience with a bulk upload via SQL or perhaps some other method. Thank you in advance
*This post is locked for comments