Hi All,
My company wants to upgrade ax 2.5 to 4.0, we all knew the step would be 2.5 -> 3.0 then 3.0 to 4.0
Our Platform are SQL 2000 SP 4 and Axapta 2.5 SP 2 want to upgrade Ax 3.0 SP 6 (KR1) and Ax 4.0 SP2
Our database is 140 GB, and we already shrink the data (limit the transactions) into 90 GB.
I've already done the step by step upgrade things (2.5 -> 3.0), before do the synchronize, i've upgrade the database server to sql 2005, and make the harrasment of sql 2005 (use AWE & use optimum memory). Coz Sql 2000 only have 2GB memory max.
When run the post-synchronize phase, it run batch-processing (we need to open another client axapta to process batch)
And the syntax like this "while select ..." without indexing, so it will take a lot of time for searching each record.
Previously when we use SQL2000 (it took more than 3 days) then e use SQL 2005 and it took about 22
hours.
Is there any way to optimize the data upgrade to make the process faster ?
I've already found the document how to optimize data upgrade from 3.0 to 4.0 from MBS website, but i can't find the document from 2.5 to 3.0
Any suggestions, will be very helpful.
Thanks before.
Cheers,
David S
