Join 83 other followers
Thought-Provoking Commentary for the Lawson Software Community
It’s a complaint I hear often, although not as often as I used to hear it. The upgrade programs/process was re-worked to take advantage of sqldbcopy, which solves some of the speed issues for copy jobs (i.e. tables which don’t require conversion). For those, the copying is done directly on the database server. However, some of the pre-jobs, loads, and post-jobs continue to be a bottleneck. The way I approach an upgrade is to work with the client to develop a baseline—using the Lawson-delivered programs, and then target the jobs which require tuning. For instance, a recent upgrade project looked like this:
The final result is an upgrade process that runs in about 30 hours—compared to hundreds of hours—for a 210GB database.
Can your upgrade process be improved?