Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 304 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
After SQL Server Data migration, NAV couldn't refresh data
makara
Member Posts: 25
Dear All,
I have one question. I am doing data migration of Navision DB from 2009 to 2013. whenever user do changes to master records( Customer, Vendor, Chart of Account ... ), my scripts will start after 30 minutes to transfer those modified records to Navision 2013. After finish scripts execution (I use SQL SERVER AGENT). I come to check modified data whether they are transferred or not. Then I realized, they did transfer(I used scripts to check). but when come to Navision 2013, those records are not available. To make them available, I need to re-open Navision 2013 RTC or sometimes, I need to restart Navision service.
Is there any other way to refresh data without re-open or restart service ?
Thank you for your help in advance.
Regards,
Makara
I have one question. I am doing data migration of Navision DB from 2009 to 2013. whenever user do changes to master records( Customer, Vendor, Chart of Account ... ), my scripts will start after 30 minutes to transfer those modified records to Navision 2013. After finish scripts execution (I use SQL SERVER AGENT). I come to check modified data whether they are transferred or not. Then I realized, they did transfer(I used scripts to check). but when come to Navision 2013, those records are not available. To make them available, I need to re-open Navision 2013 RTC or sometimes, I need to restart Navision service.
Is there any other way to refresh data without re-open or restart service ?
Thank you for your help in advance.
Regards,
Makara
0
Comments
Use XML Port and schedule in NAS instead, then business Logic is run as well, and data gets validated.