Data replication option with NAV 2009

sil21
Member Posts: 55
We have a client with 2 locations running NAV 2009 RTC. The two locations run as one company in NAV, and do a lot of inventory transfers back and forth. One location is remote, and in a very rural area with undependable internet access. This location does most NAV functions; purchase order entry and receiving are mission critical at this location. We are faced with 2 issues - the speed is slow on a regular basis, and we face the potential of the connection going completely down on an occassional basis.
The hardware folks would like to have a separate app and db server at remote location which then recplicates with the main database server's data. (I'm not sure if this is officially clustering....which I know is not supported). With this configuration, the remote location could run without any connectivity, and the performance would be as good as local performance. The bandwidth would be used only for data replication.
Has anyone done anythning like this before ?
We have proposed a emergency local copy of nav for when the connection is down, and this would only run the mission critical operation. We would then write some code to port the new purchases and receipts to the main system when the connection is back. Not too flashy ... and does not solve their speed issues ....
The hardware folks would like to have a separate app and db server at remote location which then recplicates with the main database server's data. (I'm not sure if this is officially clustering....which I know is not supported). With this configuration, the remote location could run without any connectivity, and the performance would be as good as local performance. The bandwidth would be used only for data replication.
Has anyone done anythning like this before ?
We have proposed a emergency local copy of nav for when the connection is down, and this would only run the mission critical operation. We would then write some code to port the new purchases and receipts to the main system when the connection is back. Not too flashy ... and does not solve their speed issues ....
0
Comments
-
I suggest to look at LS Retail replication. It's perfect fit for what you are looking. They have built a solution for stores to run on local server and replicate the data.
The only issue is that It's Retail solution so separating replication object from Retail will be an issue.0 -
http://www.rapidionline.com/products/replicator-for-ms-dynamics-nav
is a very good solution and it works like LS retail replicator, without the pain to buy the entire LS retail solution!0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions