NAV 2013 Upgrade - Conversion of Exe

SmitaDubai

Dear Everyone,

We are doing the data migration from NAV 5.0 to NAV 2013. Now we have successfully converted the DB into 2009.

All the steps we are doing exactly as per the quick-guide provided in the product CD.

Now while doing the migration from NAV 2009 to NAV 2013, the Step 1 data migration is also completed successfully.

Right now we are at point No. - 10 of the quick guide document. (10. Create the New Microsoft Dynamics NAV Database.
This involves installing Microsoft Dynamics NAV 2013, and then opening your database in the Microsoft Dynamics NAV 2013 development environment. ). Basically it will ask you a confirmation before converting, and the conversion will start. We started this long time back , almost 17 hours. But still not completed. The Database size is 300 GB , its having 6 companies.

Right now it showing 'Altering the DB XYZ....company name ABC' in the dialogue box. And DB not responding.

Do you guys think it should take this much of time ?? ???

Pls help :-)

saravanans87

It is quite normal. It will take some time to do the conversion.For me a 6 GB database took 30 minutes(from 2009 to 2013).


Thanks - Saravanan

ppavuk

It is quite ok. It does takes a lot of time. For one of customers, who had a similar size Db we even built a new box with ultra-fast ssd drives, as it has not been possible to convert DB over weekend...

SSD improves things a lot, probably 4-5x faster than on the SAN drives...

SmitaDubai

Thanks you so much for your replies.

The system is getting hanged during this process .Is it normal ?

I request other people to comment as well so that we can get more clarity .

Smita.

kriki

It seems the system is hanging because NAV is sending continually requests to SQL and SQL needs also some time to process the request.
The type of requests send to SQL are statements to change the text-fields from VARCHAR to NVARCHAR in SQL and that takes time. It makes also grow the database and the TL logfile.
A few ways to speed up all:
-pregrow the DB-size and the TL-file to dimensions that you expect it will get. Put the autogrowth to 1 GB for the upgrade. This makes the file grow big portions in 1 go. The more times it needs to grow, the longer it takes.
-remove/disable all secondary indexes from the big tables that are not needed for the upgrade and recreate them later

Another reason that it takes time is that NAV needs to scan all dimensions and convert them to the new dimension-system.

SmitaDubai

Thank you Kriki for your suggestions.

Yesterday night , the conversion got completed successfully after 31 hrs. \:D/

Next time I will try your given steps for sure to speed up the process.

ppavuk

Just do this on ultra-fast SSD next time, they finally are cheaper that time