Sage 100

Doing test upgrade of large company from Sage 100 Advanced 4.3 to Sage 100 Premium 2014. 20GB of data with Kissinger EDI add on. Converting to Sage 100 Advanced 2014 took 15 hours. Then converting from Sage 100 Advance to Sage 100 Premium took 20 hours. We've talked to Sage and they don't have ideas but say there's a lot of data and sometimes a third party add on can slow things down. We've optimized the SQL server but didn't help much. If nothing changes client could be down for several days during live conversion. Any idea? TIA

Purge History. Consider zapping some of the bigger tables and recreating then in SQL. We moved a client from v4.3 Advanced to v2013 SQL and went from a 40 hour conversion to about 15 hours

Thanks Robert. We've been discussing that. Did you go directly from 4.3 Advance to the SQL version?

Yes, we did go directly. I reviewed the log file for the time it took on each file and the longer ones, we revisited. SO_SalesHistory was never used in any reports that the client used, so we purged a lot of that table.

Thanks much Robert. That's very helpful.

I had a similar experience upgrading from 4.20 advanced to 2014 premium. My source company code data was almost 11 GB but I managed to get rid of all the .old and temp files, reducing the size to 6 GB. The initial data conversion to Providex 2014 took six and a half hours, followed by 16 hours conversion to SQL. Needless to say I did this over the weekend as the client couldn't be down that long.

Thanks John.

I have used SQL mirroring to assist with SQL conversions. I had files that were taking 16 hours each and I was about to shrink the conversion to 15 minutes. The key is once the data is in SQL mirror you can write a query to populate the new data table instead of sage populating the table via he conversion . It was a LOT faster. One think to remember is that you only need to do this for large files not all of them. Let me know if you need more info. I can share the queries I used to populate the SQL tables.

Thanks Jim. I appreciate the reply. I'll pass this on to the consultant helping with the conversion and let you know.

@JimWoodhead - Very interesting....

If start the conversion Friday at 4pm. If you've tested and it converts without errors then this should just be a babysitting issue.