Hi All, I'm having problem with upgrade version axapta from 2.5 to 3.0.
Our Platform are SQL 2000 SP 4 and Axapta 3.0 SP 6 (KR1) 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 until post-synchronize phase. When run the post-synchronize phase, it run batch-processing (we need to open another client axapta to process batch) And when it run Class ReleaseUpdateDB_V30toV30SP method updateCustSalesLinkTable() . it takes more than 2 days and it still running until now (not finished yet). i've already seen inside the method, it will query to tables : CustConfirmTrans CustConfirmjour CustQuotationTrans CustQuotationJour CustPickingListTrans 6.582.261 CustPickingListJour 778.989 CustPackingSlipTrans CustPackingSlipJour CustInvoiceTrans 15.920.771 records CustInvoiceJour 2.038.269 records And the syntax like this "while select ..." without indexing, so it will take a lot of time for searching each record. Should i upgrade to SQL 2005 for the database server first, Does it matter ? when is the best moment for upgrade ? And can i open more than 1 client to run the batch processing, i think it will perform faster ? Any suggestions, will help a lot. Thanks before. Cheers, David S [Non-text portions of this message have been removed]
