In November 2010 I blogged about Transferring small amount of data between databases.  There I had a Form that can read and write a XML file with table data.  This Form was used frequently in my company to move data between companies and databases.

The good thing about this method is that I can move data between database versions.

XMLDataTransfer

Yesterday I got a request to share a NAV 2013 R2 version of this solution.  Here it is !

This version includes support for BLOB data in the tables.  BLOB data is converted to Base64 and included in the XML file.

Be careful when importing.  Existing data will be overwritten.

Dynamics XML Data Transfer for NAV 2013 R2

2 thoughts on “Using XML to transfer Data between NAV companies

  1. Prajeesh says:

    Hi Gunner,

    I have a different requirement in mind. I need to copy new or Modifyed Records from master and Setup tables from a Template DB to other MC Dbs. The Table will have similar structure. This should be automated.

    Any suggestion, Please help me. Thanks

    1. Hi. I would begin by using the database triggers to trigger the XML export (http://www.dynamics.is/?p=1776) and work forward from there.

Leave a Reply

%d bloggers like this: