Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
Options
Push Data for different database
julkifli33
Member Posts: 1,073
Hi All,
I have a question. what is the best and safest way to push data from DB01 to DB02
assuming these 2 DBs are same structure.
for example I created data in Item Card in DB01
then i want to be sync every 1 hour to DB02.
options are :
1. export data from DB01, import from DB02
2. use store procedure
3. any other options?
Thanks for any advice
I have a question. what is the best and safest way to push data from DB01 to DB02
assuming these 2 DBs are same structure.
for example I created data in Item Card in DB01
then i want to be sync every 1 hour to DB02.
options are :
1. export data from DB01, import from DB02
2. use store procedure
3. any other options?
Thanks for any advice
0
Comments
which NAV-Version?
If you use NAV2016 or newer, you can create a additional table in DB02 with property "ExternalSQL".
This table should be linked to table "Item" in DB01.
After that, you can create a codeunit in DB02 and sync table data from table1 to table2.
Use Job Queue to run this function every 1 hour.
thanks for the reply.
I am using Nav 2017
by the way is this applicable only for same server?
DB01 and DB02 must not use the same server.
Please take a look at the documentation:
https://docs.microsoft.com/en-us/dynamics-nav/tabletype-property
thanks a lot for the info
will try for that
Thanks !