Hi,
I have a problem with the upgrade toolkit. My customer's database has over 9 millions records in the Ledger Entry Dimension table. When I am Transfer data from in Step 2 of upgrade. It get stalled when it hits the following function.
UpdateLedgerDim(StateIndicator);
When I comment it out. The Transfer data is much faster and I was able to continue.
I looked into the code figure out it is just renaming tables ID to what it should be in the new version. So I wrote a SQL script that does a similar trick.
UPDATE dbo.[TOC$Ledger Entry Dimension] SET = 37032300 WHERE = 14020010
Does anyone has similar problem? and also is the way that I am doing now ok?
0