Best way to migrate data from NAV3.7 to NAV5.0

gison

Dears,

This is the current situation I encountered.
We are going to upgrade Navision from 3.7 to 5.0.

1. NAV 3.7 base on SQL Server 2000
2. NAV 5.0 base on SQL Server 2005
3. Two application has some difference on the table schema.
=================================================================
At the moment I'm surveying three solution:
A. Writing a SQL script to migrate data
B. Writing a SSIS to migrate data
C. Use data port to do the migration.
=================================================================

Do you guys have any suggestion on this kind of situation.
Since I really don't have too much idea on that.

Deeply thank you,
gison

ara3n

There is an upgrade toolkit on partnersource that you download and upgrade from 3.7 to 5.0
Read the PDF document and follow the steps.

https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&NRORIGINALURL=/partnersource/downloads/releases/microsoftdynamicsnav50.htm?printpage=false&NRNODEGUID={32B8CE1F-4D49-455E-B4C3-39F4D0DAF8F0}&NRCACHEHINT=Guest&printpage=false&wa=wsignin1.0

gison

thank you for the information.
I'll have a look it.