Push Data for different database

julkifli33

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

joerg_renz

Hello,
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.

julkifli33

Hi joerg_renz,
thanks for the reply.
I am using Nav 2017
by the way is this applicable only for same server?

joerg_renz

Hi,
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

julkifli33

Hi joerg_renz,
thanks a lot for the info
will try for that
Thanks !

julkifli33

Hi any idea how to make this externalname for multiple companies?