Any metrics of timing regarding Native NAV 2009 R2 to SQL?

howieb4

Hi. I am testing a migration from native NAV 2099 R2 to SQL. The company I am migrating is primarily used for payroll only, with minimal AP activity.
I am following the instructions in the Upgrade instructions from the 2009 DVD. I am running the first set of database tests and the process is running extremely slow. The testing process got through the first set of tests in about 30 minutes, and then it moved into the 2nd set. It basically came to a halt at 38% in the Payroll Ledger Entry Table. It has progressed to 40% in the last hour.

Now I am running this database test with the database residing on an external drive, which I guess is slowing it down a bit. The db is just under 5GB.

Does anyone have some timing metrics on how long this should take?

Thanks

jglathe

Hi howieb4,

5GB database size is not very big for a NAV DB. My recommendation would be to get a half-decent laptop with an SSD, this increases the speed of the native DB dramatically. I am talking about >10times faster. I have a 40GB customer database (native), it gets rebuilt on my T420s with SSD from .fbk in way under an hour.
Also, I would recommend to increase database size before conversion. No need to save disk space at these sizes with today's hardware.

with best regards

Jens

kriki

Some other thingies that might help:
-pre-grow DB and TL so they don't need to grow on-the-fly.
-disable indexes you don't need
-create new indexes in case they would be needed
(the last 2 need some investigation in the upgrade-code)