# Data to a Mysql database

**URL:** <https://www.dynamicsuser.net/t/data-to-a-mysql-database/25410>\
**Category:** Developer Forum\
**Created:** [May 4, 2010, 4:50pm UTC](https://www.dynamicsuser.net/t/data-to-a-mysql-database/25410 "2010-05-04T16:50:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![armikwen](https://avatars.discourse-cdn.com/v4/letter/a/e19adc/32.png) [@armikwen](https://www.dynamicsuser.net/u/armikwen)\
**Post date:** [May 4, 2010, 4:50pm UTC](https://www.dynamicsuser.net/t/data-to-a-mysql-database/25410/1 "2010-05-04T16:50:17Z")

</div>

Hello,

I am in the process of transferring data and contacts onto a Mysql database.

I have had some help and am trying to get a software solution.

So main features would be to migrate large amounts of data and contacts every day. The migration would be done manually.

Thanks for the help.

---

<div class="post-metadata">

**Author:** ![Darius555](https://avatars.discourse-cdn.com/v4/letter/d/da6949/32.png) [@Darius555](https://www.dynamicsuser.net/u/Darius555)\
**Post date:** [May 4, 2010, 7:04pm UTC](https://www.dynamicsuser.net/t/data-to-a-mysql-database/25410/2 "2010-05-04T19:04:20Z")

</div>

Hello I think you have three ways

1. Simpliest - to Use dataports from Navision (very slow and not real time solution)

2. Use MySQL ODBC driver from Navision (slow too)

3 Use C/FRONT solution, in this way you will need to connect to NAV from MySQL and cpature data (speed is very close to native navision speed)

Bye

---

<div class="post-metadata">

**Author:** ![Darius555](https://avatars.discourse-cdn.com/v4/letter/d/da6949/32.png) [@Darius555](https://www.dynamicsuser.net/u/Darius555)\
**Post date:** [May 4, 2010, 7:56pm UTC](https://www.dynamicsuser.net/t/data-to-a-mysql-database/25410/3 "2010-05-04T19:56:25Z")

</div>

Sorry I’ve seen later that talk is about AX ☹

---

<div class="post-metadata">

**Author:** ![Harish](https://avatars.discourse-cdn.com/v4/letter/h/47e85d/32.png) [@Harish](https://www.dynamicsuser.net/u/Harish)\
**Post date:** [May 5, 2010, 10:16am UTC](https://www.dynamicsuser.net/t/data-to-a-mysql-database/25410/4 "2010-05-05T10:16:20Z")

</div>

Hi Mik,

I suppose you are running SQL database as back end. If there are not too much problems like difference in data type etc, try to move data from SQL Server directly.

Otherwise you might want to consider using open source ETL products like [Talend](http://uk.talend.com/index.php).

Regards,
