Update NAV7 Step 2

wolfverinew · 2013-04-26

Good morning,

I'm doing a migration to Nav 7 am in STEP 2 tranfer data. I have a 90 gb BD and takes more than 24 hours and only 25% goes, this is normal? I'm very concerned about what times.

Anyone have some info??

Marije_Brummel · 2013-04-26

I guess it really depends where the 90GB is located.

Any idea which table/process takes so long? Have you profiled the transaction?

wolfverinew · 2013-04-26

Mark Brummel wrote:

I guess it really depends where the 90GB is located.

Any idea which table/process takes so long? Have you profiled the transaction?

If, in G / L entry, has 18408861 records.

It's where you take all the time but not if it is normal or not.

Thank you,

Marije_Brummel · 2013-04-26

18 million is a lot.

I would profile the transaction and see if it slows down somewhere. If that does not help, then use a faster server.

Rob_Hansen · 2013-04-26

We haven't done an upgrade to NAV 2013 yet, but I've wondered about performance...particularly with the upgrade toolkit needing to restructure all the dimension subtable data into the new dimension set/dimension set ID structure. For a very large database, I'm worried how long that process could take. Is that the issue here?

Also, are you running the process locally on a very fast server/machine?

Marije_Brummel · 2013-04-29

The dimension update is done using T-SQL directly and should be fast enough.

Update NAV7 Step 2

Comments

Categories