Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Best way to migrate data from NAV3.7 to NAV5.0
gison
Member Posts: 128
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
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
0
Comments
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.0Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
I'll have a look it.