DB LINK DATA

mkpjsr

hi experts
I want to copy data from one navision database to another nav database automatically day basis. Please suggest me how i will do this?

SiSt

I guess it is hard to give you a general answer to the question. I'm an EDI developer, so I would implement an EDI process and exchange messages or files. If you use a good add-on for NAV you get logging, monitoring and error handling functionality and can configure the mapping of the fields and tables in NAV.

You can also use the webservices of NAV to exchange data between databases, there are a lot of examples in this forum and the web. It might also be possible to use SQL replication or other methods to exchange data, but as soon as you need to run validation trigger or business logic in NAV you cannot use any SQL based approach.

Juhl

Rapidi Online